MSDE SetUp Hell: Newbie Help

I am trying to setup MSDE for the very first time. So I am absolutely a
newbie. I downloaded sql2ksp3 from microsoft site. I unpacked the file to a
folder and then clicked on setup.
I get an error message about using the command line to supply a strong
password and the setup exits...
I use the command line to supply a password like
setup SAPWD="Pwd777b7" and then the setup seems to install or change some
files.
I click on the setup again and I get an error an invalid Instance name name
error. I have read and reread the (from a first user's point of view) the
very unhelpful help file I download with MSDE setup.
I have been going back and forth on this. Anyone know what's wrong... Anyone
know of a URL where I can find a step-by-step method of installing MSDE.
Thanks in advance
hi,
JP Bless wrote:
> I am trying to setup MSDE for the very first time. So I am absolutely
> a newbie. I downloaded sql2ksp3 from microsoft site. I unpacked the
> file to a folder and then clicked on setup.
> I get an error message about using the command line to supply a strong
> password and the setup exits...
> I use the command line to supply a password like
> setup SAPWD="Pwd777b7" and then the setup seems to install or change
> some files.
you should have a new default instace of MSDE installed, with no network
protocols enabled and allowing only Windows authenticated connections..
please verify using the Windows Services applet (control panel->management
tools->services) you have a MSSQLSERVER and SQLSERVERAGENT entry for the
related services...

> I click on the setup again and I get an error an invalid Instance
> name name error.
it failed as you tried that way to install a second default instance of MSDE
and ony 1 default instace is allowed... you can install other (up to 15, for
a max of 16 instances in total) named instances providing the additional
parameter
INSTANCENAME=whatever_name

>I have read and reread the (from a first user's
> point of view) the very unhelpful help file I download with MSDE
> setup.
> I have been going back and forth on this. Anyone know what's wrong...
> Anyone know of a URL where I can find a step-by-step method of
> installing MSDE.
>
if you can read/understand french,
http://perso.wanadoo.fr/jm.doudoux/m...msde/msde.htm, if you can
read/understand italian, http://www.visual-basic.it/articoli/scMsde01.htm,
but I do not know english sites
anyway, you should not just click on the setup.exe boostrap installer but
call it from a command window and provide all the required parameters,
usually (depending on your needs) in the form of
c:\...\>setupe.exe INSTANCENAME=whatever SAPWD=your_strong_pwd
SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 /L*v "C:\MSDELOG.txt"
this typical command line will install a named instance named "whatever",
with "sa" login pwd = "your_strong_pwd", enabling SQL Server standard
connections (mixed mode authentication, allowing both integrated security a
standard SQL Server connections), enabling network protocols and thus
enabling remote connections and finally enabling verbose logging of the
installation process to a text file of about 2mb for a successfull
installation you can inspect in case of troubles for
RETURN VALUE 3
entries... this entries are localized in the particular MSDE localized
flavour, and about 10/15 lines before each entry some (sometime cryptic)
description of the problem will be reported...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea. It helped. Now I am done with with installation, I guess I
just cleared the first hurdle. My next task is to know how to add tables and
queries. I see there is no GUI (like Enterprise Manager) in the full/server
version, to administer/add table/Queries etc. Any tips where to begin?
Once again, thanks for the help, I really appreciate it.
Joe
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3rv3laFloeqnU1@.individual.net...
> hi,
> JP Bless wrote:
> you should have a new default instace of MSDE installed, with no network
> protocols enabled and allowing only Windows authenticated connections..
> please verify using the Windows Services applet (control panel->management
> tools->services) you have a MSSQLSERVER and SQLSERVERAGENT entry for the
> related services...
> it failed as you tried that way to install a second default instance of
MSDE
> and ony 1 default instace is allowed... you can install other (up to 15,
for
> a max of 16 instances in total) named instances providing the additional
> parameter
> INSTANCENAME=whatever_name
>
> if you can read/understand french,
> http://perso.wanadoo.fr/jm.doudoux/m...msde/msde.htm, if you can
> read/understand italian, http://www.visual-basic.it/articoli/scMsde01.htm,
> but I do not know english sites
> anyway, you should not just click on the setup.exe boostrap installer but
> call it from a command window and provide all the required parameters,
> usually (depending on your needs) in the form of
> c:\...\>setupe.exe INSTANCENAME=whatever SAPWD=your_strong_pwd
> SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0 /L*v "C:\MSDELOG.txt"
> this typical command line will install a named instance named "whatever",
> with "sa" login pwd = "your_strong_pwd", enabling SQL Server standard
> connections (mixed mode authentication, allowing both integrated security
a
> standard SQL Server connections), enabling network protocols and thus
> enabling remote connections and finally enabling verbose logging of the
> installation process to a text file of about 2mb for a successfull
> installation you can inspect in case of troubles for
> RETURN VALUE 3
> entries... this entries are localized in the particular MSDE localized
> flavour, and about 10/15 lines before each entry some (sometime cryptic)
> description of the problem will be reported...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Joe,
JP Bless wrote:
> Thanks Andrea. It helped. Now I am done with with installation, I
> guess I just cleared the first hurdle. My next task is to know how to
> add tables and queries. I see there is no GUI (like Enterprise
> Manager) in the full/server version, to administer/add table/Queries
> etc. Any tips where to begin?
>
my tip is to use the prj you can find at the link following my sign., which
provides free a user interface similar to Enterprise Manager written in vb6
on top of SQL-DMO object model as long as a lot of dynamic SQL :D, but I'm
deeply involved in that advice :D
you have further choices, both commercial and free at
http://www.microsoft.com/sql/msde/partners and
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks a million... I appreciate the help. I will look at the sites and
tools.
Once again thanks.
Joe
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3rvco3FkpmcvU1@.individual.net...
> hi Joe,
> JP Bless wrote:
> my tip is to use the prj you can find at the link following my sign.,
which
> provides free a user interface similar to Enterprise Manager written in
vb6
> on top of SQL-DMO object model as long as a lot of dynamic SQL :D, but I'm
> deeply involved in that advice :D
> you have further choices, both commercial and free at
> http://www.microsoft.com/sql/msde/partners and
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

MSDE sa password - newbie

I downloaded and installed (somehow) MSDE a couple weeks ago but have not used it. Now I try to access MSDE using sa account but it does not accept an empty password and I do not remember providing one at install. MSDE appears to be installed because I se
e data files at C:\Program Files\Microsoft SQL Server\MSSQL$VSDOTNET\Data. Is there any way I can start using this install or do I need to start all over?
hi Mike,
"Mike" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:C864FCBB-655C-4D66-9DC4-9215C74A47C7@.microsoft.com...
> I downloaded and installed (somehow) MSDE a couple weeks ago but have not
used it. Now I try to
>access MSDE using sa account but it does not accept an empty password and I
do not remember
>providing one at install. MSDE appears to be installed because I see data
files at C:\Program
>Files\Microsoft SQL Server\MSSQL$VSDOTNET\Data. Is there any way I can
start using this install or
>do I need to start all over?
you probably changed the sa password...
try login in using a trusted authenticated Windows login member of the
sysadmin group
all sysadmin are granted privilege to modify password of other user...
then execute (osql, or the query tool of your choice)
EXEC sp_password @.new = 'new_password', @.loginame = 'sa'
in order to modify the forgotten sa pwd..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi,
If you have not provided a password for the SA login at installation time,
then it should be blank and it should accept it.
What I doubt is the Server name that you would be entering to connect to
the MSDE.
From the folder name that you have sent, I understand that it is a named
instance and you should use "computername\Instancename", in your case
"Computername\VSDOTNET", replace computername with the name of your
computer and try it.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

MSDE newbie quetsion: importing data from SQL Server

I've been given a file with no extension, and told that it's "a full
export from our SQL server tables".
What sort of file is this likely to be, and is there any way I can
import it into MSDE?
Simon Elliott http://www.ctsn.co.uk
hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:u5XG0NwQEHA.3728@.TK2MSFTNGP10.phx.gbl...
> I've been given a file with no extension, and told that it's "a full
> export from our SQL server tables".
> What sort of file is this likely to be, and is there any way I can
> import it into MSDE?
it really depend what kind of file it is...
it can be a full backup of a database, and you can test it executing from
any query tool
RESTORE HEADERONLY
FROM DISK = 'c:\....\filename'
which returns a result set indicating the content, if any and valid, of the
potential backup, or something like
Server: Msg 3242, Level 16, State 1, Line 1
The file on device 'd:\cursor.txt' is not a valid Microsoft Tape Format
backup set.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.
it can even be a DML sql file, containing a list of INSERT INTO statements
you have to execute to load an existing table... or a bulk copy export you
have to bulk insert..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:%23ba4YhDREHA.3124@.TK2MSFTNGP12.phx.gbl...
> On 27/05/2004, Simon Elliott wrote:
> Is there a MSDE based on SQL Server 2000 available for free download?
>
yese, you can get the package at
http://www.microsoft.com/sql/msde/do...s/download.asp

> If so, how do I uninstall the current version? I've had no luck trying
> to uninstall it so far, as the uninstaller tells me that the service is
> still running, even if I have stopped it.
>
the uninstall applet shoul'd work as expected, but you can read
http://support.microsoft.com/default...oduct=sql&FR=1
for some hints on how to manually uninstall SQL Server 7.0 version...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||On 28/05/2004, Andrea Montanari wrote:
> yese, you can get the package at
> http://www.microsoft.com/sql/msde/do...s/download.asp
>
> the uninstall applet shoul'd work as expected, but you can read
> http://support.microsoft.com/default...276044&Product
> =sql&FR=1 for some hints on how to manually uninstall SQL Server 7.0
> version... --
OK, I'll give that a try. Thanks again for all your help.
Simon Elliott http://www.ctsn.co.uk

MSDE newbie question: contents of default databases

Having installed MSDE and connected to it, it seems there are several
default databases already:
master
model
msdb
tempdb
Are these intended to be for any specific use?
How do I get a list of the tables that are in these databases?
Simon Elliott http://www.ctsn.co.uk
hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:ureI8NzQEHA.1624@.TK2MSFTNGP09.phx.gbl...
> Having installed MSDE and connected to it, it seems there are several
> default databases already:
> master
> model
> msdb
> tempdb
> Are these intended to be for any specific use?
> How do I get a list of the tables that are in these databases?
in order to limit distribution size, MSDE only ships with system database
you do not have to touch =;-D
these databases are relatated to MSDE itself and are not user database...
if you like some sample database, you can install the Northwind and Pubs
demo databases from
http://www.microsoft.com/downloads/d...DisplayLang=en
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE newbie question: connection strings

I installed MSDE on a Windows XP SP1 PC on our network. We don't have a
domain controller.
If I access this database via ADO, how do I construct the connection
string? As I understand it, this is of the form:
Provider=SQLOLEDB; Data Source=server_name; Initial
Catalog=database_name; User ID=username; Password=password;
Is the server name just the name or IP address of the PC running MSDE?
Are there any other subtleties I should be aware of?
Simon Elliott http://www.ctsn.co.uk
hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:OuUGwZwQEHA.3580@.TK2MSFTNGP11.phx.gbl...
> I installed MSDE on a Windows XP SP1 PC on our network. We don't have a
> domain controller.
> If I access this database via ADO, how do I construct the connection
> string? As I understand it, this is of the form:
> Provider=SQLOLEDB; Data Source=server_name; Initial
> Catalog=database_name; User ID=username; Password=password;
> Is the server name just the name or IP address of the PC running MSDE?
> Are there any other subtleties I should be aware of?
if the MSDE instance has been installed as the default intance, it's name
will just be the ComputerName and/or it's IP address... if it has been
installed as a named instance, it's name will be
ComputerName\InstanceName...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE newbie question

Hey All -
I need to develop a database that will be approximately 100 MB in size
and will have approx 15 concurrent users. I am attempting to
understand what my Microsoft database options are. Clearly Access is
one. What about MSDE? Do I need to purchase a copy of SQL Server to
utilize the MSDE technology? If so, which edition/CALs do I need?
Thanks for helping this DB rookie out.
Dave
It sounds like MSDE would work fine for your needs, depending on how often
the 15 user hit the server. Here is a link to some information about the
appropriate uses for MSDE:
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
For a multi-user network client server application with a low number of
users MSDE is a very good choice. Purchasing a copy of SQL Server is not
necessary, although I would recommend buying the Developers Edition of SQL
Server ($50) for the development tools it provides and the ability to test
your application on SQL Server.
Personally, I wouldn't bother with Access as a backend data store.
Jim
"dave" <thorung@.mailcity.com> wrote in message
news:f9e0449e.0404201837.5eefeade@.posting.google.c om...
> Hey All -
> I need to develop a database that will be approximately 100 MB in size
> and will have approx 15 concurrent users. I am attempting to
> understand what my Microsoft database options are. Clearly Access is
> one. What about MSDE? Do I need to purchase a copy of SQL Server to
> utilize the MSDE technology? If so, which edition/CALs do I need?
> Thanks for helping this DB rookie out.
> Dave

MSDE Newbie Blooper

Another newbie here, hope yaw dont mind!
Yes I am redneck newbie
I have been using access for a few years and have decided to further
educate myself(untrain) and start allover withh SQL. I have the developers
edition of SQL 2000 and VisualStudio.net 2003, I did look at SQL 2005
Express. I know the newer the better, but as of this time I cannot afford to
take the plung for the devlopers edition of SQL 2005. So back to my
questions.
I am learning here so take it easy on me. I got SQL 2000 loaded and I can
access the server, make tables,etc,
I cant get MSDE to work in VS for some reason?(dont know what I am doing
probably) Every time I lanch VS and try to connect to the database, I get
"VS can only connect using MSDE,etc".I did download MSDE2000 and installed
as per instruction went to a command prompted and entered Setup.exe /qb+
INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR
SA PASSWORD>
as told, an error was promtped, saying to go to the control panel to make
changes?
-not what the instructions said-
, anyhow, to make it short, can someone point me in the right direction to
make this work so I can start doodling in my mind with what I have ahead of
me..
I have order a few books to enrich my tastebuds with whats ahead, but I like
jumping in over my head first..
Thanks in advance
David W
hi David,
DavidW wrote:
>...
> I cant get MSDE to work in VS for some reason?(dont know what I am
> doing probably) Every time I lanch VS and try to connect to the
> database, I get "VS can only connect using MSDE,etc".
I think to rember that the Standard edition of VS2003 only allowed to
connect to MSDE and not to full blown editions...

>I did download
> MSDE2000 and installed as per instruction went to a command prompted
> and entered Setup.exe /qb+ INSTANCENAME=VSDOTNET
> DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD>
> as told, an error was promtped, saying to go to the control panel to
> make changes?
> -not what the instructions said-
> , anyhow, to make it short, can someone point me in the right
> direction to make this work so I can start doodling in my mind with
> what I have ahead of me..
try adding the
/L*v "c:\MsdeLog.txt"
parameter to your setup syntax in order to enable verbose logging of the
installation process.. this will result in an about 2mb text file (for a
succesfull installation) you can inspect in case of troubles..
seek for
RETURN VALUE 3
entries, and about 10 lines before each entry some (sometime cryptinc)
description of the problem will be reported...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE newbie

Hi guys,
I am a new user in msde and I'm wondering what do I need to get it to work. Currently I've already got the engine installed on my pc. So where do I go from here? Thanks in advance.

Ok, I managed to find out that MSDE can be utilized from the web matrix. I went through the walkthrough provided on the web matrix homepage and was able to create a database of my own. However, now I've got another problem. When I run the aspx page in the web matrix server, everything works. However, when I run it using the IIS, the following error is thrown:

Server Error in '/chapter9' Application.

---

Login failed for user 'silvertype\ASPNET'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.Data.SqlClient.SqlException: Login failed for user 'silvertype\ASPNET'.
Source Error:

Line 7: Line 8: conPubs = New SqlConnection( "server='(local)'; trusted_connection=true; database='pubs'" )Line 9: conPubs.Open()Line 10: cmdSelectAuthors = New SqlCommand( "Select au_lname From Authors", conPubs )Line 11: dtrAuthors = cmdSelectAuthors.ExecuteReader()

Source File:C:\Inetpub\wwwroot\aspnet_unleashed\chapter9\sqldatareader.aspx Line:9
Stack Trace:

[SqlException: Login failed for user 'ROGER\ASPNET'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 ASP.SqlDataReader_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in C:\Inetpub\wwwroot\aspnet_unleashed\chapter9\sqldatareader.aspx:9 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +27 System.Web.UI.Control.Render(HtmlTextWriter writer) +7 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243 System.Web.UI.Page.ProcessRequestMain() +1926

---

Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032

My Code is as below:
<%@. Page Language="VB" Debug="True" %>
<%@. import Namespace="System.Data.SqlClient" %>
<%
Dim conPubs As SqlConnection
Dim cmdSelectAuthors As SqlCommand
Dim dtrAuthors As SqlDataReader

conPubs = New SqlConnection( "server='(local)'; trusted_connection=true; database='pubs'" )
conPubs.Open()
cmdSelectAuthors = New SqlCommand( "Select au_lname From Authors", conPubs )
dtrAuthors = cmdSelectAuthors.ExecuteReader()
While dtrAuthors.Read()
Response.Write( "<li>" )
Response.Write( dtrAuthors( "au_lname" ) )
End While
dtrAuthors.Close()
conPubs.Close()
%>
Any idea what's wrong?

|||Yes. You either need to grant the windows ASPNET account privilleges for your SQL Server instance, or you need to get rid of the trusted_connection parameter and specify an SQL login (i.e. uid=sa; pwd=password;) in your connection string. I would go with the latter when using MSDE as it is alot easier.|||

IC...Finally, I managed to get it to work. Thanks a lot. Guys like you really make this community a wonderful place :)

|||Not a problem. Glad I could help.

MSDE Newbie

Are there any good online resources for learning how to use MSDE?
I've been using MS-Access for years via ADO but want to try MSDE.
Thanks in advance for any suggestions
..
I suggest you
http://www.microsoft.com/sql/msde/techinfo/default.asp
"McKirahan" wrote:

> Are there any good online resources for learning how to use MSDE?
> I've been using MS-Access for years via ADO but want to try MSDE.
> Thanks in advance for any suggestions
> ..
>
>
|||Also some tips on your learning path:
1> Read about SQL Server from booksonline or some decent book
2> Just keep in mind that MSDE is a smaller version for SQL Server. Most of the related books are for sql server and hardly mention MSDE, but if you need a quick starter book on how to use MSDE, then get "Beginning Visual Basic .Net databases", it does r
efer to MSDE all the time (but is for VB.Net..)..
I would also suggest that you go thru this newsgroups' posting from past few months.. don't worry, it is not boring and too lengthy.. it's a good read. You will know what problems other people are having and how to tackle them and you will become familia
r with the MSDE world..
And then there are MS KB articles for many issues related to MSDE..
hope it helps..
dev
|||"dev_kh" <devkh@.discussions.microsoft.com> wrote in message
news:8A2E518D-07D5-4B27-990E-134E841F8036@.microsoft.com...
> Also some tips on your learning path:
> 1> Read about SQL Server from booksonline or some decent book
> 2> Just keep in mind that MSDE is a smaller version for SQL Server. Most
of the related books are for sql server and hardly mention MSDE, but if you
need a quick starter book on how to use MSDE, then get "Beginning Visual
Basic .Net databases", it does refer to MSDE all the time (but is for
VB.Net..)..
> I would also suggest that you go thru this newsgroups' posting from past
few months.. don't worry, it is not boring and too lengthy.. it's a good
read. You will know what problems other people are having and how to tackle
them and you will become familiar with the MSDE world..
> And then there are MS KB articles for many issues related to MSDE..
> hope it helps..
> dev
Thanks for the suggestions, I'll check them out. However, I was hoping for
some site suggestions along the lines of "w3schools" or "devguru"; that is,
more of an introduction to MSDE and not the full blown Microsoft approach.

MSDE newbie

I Just installed MDSE2000A (ithink it already comes with SP3a), by doing
Setup.exe /qb+ INSTANCENAME=MOC DISABLENETWORKPROTOCOLS=1 SAPWD=moc
I downloaded the northwind database and tried to install it by doing
osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
Databases\northwind.mdf'"
the response was
[Shared Memory]Invalid connection.
[Shared Memory]ConnectionOpen (Invalid Instance()).
what have I done wrong?
You did not specify th instance you want to connect to, this can be done
with the switch -S
osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
Databases\northwind.mdf' -SServername\Instancename
Would be on the the local server ".\MOC"
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joo Costa" <JooCosta@.discussions.microsoft.com> schrieb im Newsbeitrag
news:520F0379-78B1-449C-9864-896E04C5C910@.microsoft.com...
>I Just installed MDSE2000A (ithink it already comes with SP3a), by doing
> Setup.exe /qb+ INSTANCENAME=MOC DISABLENETWORKPROTOCOLS=1 SAPWD=moc
> I downloaded the northwind database and tried to install it by doing
> osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
> Databases\northwind.mdf'"
> the response was
> [Shared Memory]Invalid connection.
> [Shared Memory]ConnectionOpen (Invalid Instance()).
> what have I done wrong?
|||thanks, now I have unather problem, I transcribed the line below:
osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
Databases\northwind.mdf'" -S.\MOC
the answer was:
Msg 5105, Level 16, State 4, Server RAINBOWARRIOR\MOC, Line 1
Device activation error. The physical file name 'c:\SQL Server 2000 Sample
Databases\northwind.mdf' may be incorrect.
"Jens Sü?meyer" wrote:

> You did not specify th instance you want to connect to, this can be done
> with the switch -S
> osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
> Databases\northwind.mdf' -SServername\Instancename
> Would be on the the local server ".\MOC"
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Jo?o Costa" <JooCosta@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:520F0379-78B1-449C-9864-896E04C5C910@.microsoft.com...
>
>
|||The problem is that there are spaces in the pathname, if you could get
around this you should use a simple path which doesnt contain any space
perhaps c:\sql. If you cant you have to doublequote the Quotes.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joo Costa" <JooCosta@.discussions.microsoft.com> schrieb im Newsbeitrag
news:6A7F0B79-0B83-46C3-A1D6-C48EB86E0C8B@.microsoft.com...[vbcol=seagreen]
> thanks, now I have unather problem, I transcribed the line below:
> osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample
> Databases\northwind.mdf'" -S.\MOC
> the answer was:
> Msg 5105, Level 16, State 4, Server RAINBOWARRIOR\MOC, Line 1
> Device activation error. The physical file name 'c:\SQL Server 2000 Sample
> Databases\northwind.mdf' may be incorrect.
> "Jens Smeyer" wrote:
|||thanks!
"Jens Sü?meyer" wrote:

> The problem is that there are spaces in the pathname, if you could get
> around this you should use a simple path which doesn′t contain any space
> perhaps c:\sql. If you can′t you have to doublequote the Quotes.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Jo?o Costa" <JooCosta@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A7F0B79-0B83-46C3-A1D6-C48EB86E0C8B@.microsoft.com...
>
>

MSDE NewBie

Dear all I did this.
I installed client version of SQL 2000 to connect to my server
(I can connect to my server and access the database there).
I installed MSDE2000RelA on my Win ME PC. Installation all
went smooth,(no errors). How do I use MSDE now. In the
enterprise manager I dont see any reference to MSDE. Am
I missing something. pls help
Joy -
Here is what you need to do.
First thing first , the network libraries are not enabled in MSDE by default
if it is a NAMED INSTANCE. In order to enable the libraries -
- Go to the Server Network Utilities of SQL Server from the Start Menu.
- Select the MSDE Instance from drop down list
- enable Named Pipes, TCP-IP and Shared Memory
- highlight TCP-IP and go to its Properties.
- if MSDE is a default instance then set the port number to 1433, but if it
is not a default instance then set the Port Number to 0. This will enable
dynamic port allocation.
- apply the above changes.
- close all client tools including Enterprise Manager and Query Analyser
- restart MSDE
- after restarting , Open Enterprise Manager
- right click on the SQL Server Group Icon, and select NEW SQL SERVER
REGISTRATION.
- give the details of the MSDE Instance.
You should be able to see the MSDE Instance in the EM . try connecting to
MSDE from Query Analyser.
This should help.
Regards
Pragya
"Joy H" wrote:

> Dear all I did this.
> I installed client version of SQL 2000 to connect to my server
> (I can connect to my server and access the database there).
> I installed MSDE2000RelA on my Win ME PC. Installation all
> went smooth,(no errors). How do I use MSDE now. In the
> enterprise manager I dont see any reference to MSDE. Am
> I missing something. pls help
|||Just to add to my previous posting, the MSDE by default does not get
registered in the Enterprise Manager. ...
"Joy H" wrote:

> Dear all I did this.
> I installed client version of SQL 2000 to connect to my server
> (I can connect to my server and access the database there).
> I installed MSDE2000RelA on my Win ME PC. Installation all
> went smooth,(no errors). How do I use MSDE now. In the
> enterprise manager I dont see any reference to MSDE. Am
> I missing something. pls help

MSDE installation - newbie problem

Dear all,

I have this problem with MSDE Installation:

I install MSDE then from prompt c:\sql...\msde\
I type: setup INSTANCENAME=pippo SECURITYMODE=SQL SAPWD=pp
then I restart but I see on the toolbar the icon of the SQL server but Ihaven't any Server or Service, in the Icon there is not the green signal nether the red signal, the little circle is white.

what I need to do?

thanks,
lucaHi Luca,

What version of Windows is this?

Don|||Windows XP Pro.

Now I unistall MSDE and Re-install it and now is ok.

Is the 1st time I use MSDE and I'd like t know wath's the use of SAPWD ?
and I need to indicate in the SETUP SAPWD=... etc. also uid= ?
and uid wath's

thanks,
luca|||I'm having the same problem. I'm using Windows 2000 Professional.

I do have the SQL Server 2000 CLIENT Tools installed on my computer, but as far as I know, those are just for connecting to SQL db's, it's not the actual engine; that's why I want MSDE on my machine. Would those client tools be conflicting with my MSDE installation?|||I've tried uninstalling it and then reinstalling it...

When I double click the little server icon in the tray and I go to hit the green play button, there are no services in the dropdown menu to start.

Anyone know how to solve this?|||Hi Luca,

The SAPWD switch lets you set the sa (system administrator, SQL Server's superuser) password which you shouldALWAYS do because of worms that have taken advantage of it.

uid is user id, the user you can use to log into MSDE.

Don|||Hi Matt,

I'm not sure I understand what you're saying about having the SQL Server client tools installed. You can use those to connect to and manage the engine of any SQL Server or MSDE installation on the local machine or across the network that you have permissions to access.

Do you mean that those don't include the database engine? If so, yes, that's right. So you would indeed want to install MSDE in order to use databases locally. And no, the client tools won't conflict with your MSDE installation at all.

I don't know why you aren't getting any services listed. If you go into Computer Management from the Control Panel do you have MSSQLSERVER listed under Services and Applications | Services? If so, can you start it from there?

This could be because you already had the client tools installed when you installed MSDE. So you probably have to add a registration to the local MSDE. Go into Enterprise Manager, expand Microsoft SQL Servers in the treeview, right-click on SQL SErver Group and select New SQL SErver Registration from the popup menu. In the available servers select either LOCAL (it might say LOCALHOST) or the machine name. If it isn't listed, type it in. Then complete the other steps in the wizard.

Does that solve it?

Don|||Don:

Since my last post I UNinstalled MSDE. You did clear up a lot for me though. I was unsure if the Client Tools were somehow conflicting, but now I know they won't.

I'll REinstall MSDE and register it in Enterprise Manager and see what happens.

Thanks for your help!

MSDE Help

I have never done anything with databases, so I am a newbie. My goal is to install an ASP.NET forum, but I need MSDE installed. I downloaded MSDE from the Microsoft website. When I run the setup.exe file, I get an error. It says:

A strong SA password is required for security reasons. Please use SAPWD switch to supply
same. Refer to readme for more details. Setup will now exit.

I looked at the documentation but could not find anything usefull, what do I have to do to install it. Thanks in advance for responses.Did you try the instructions here?Installing MSDE For ASP.NET Web Matrix Also, if you follow links from there you are led toInstalling a New Instance of MSDE 2000 SP3a which may also help.

Terri|||ok, I followed the instructions, but got yet another error.

The Windows Installer Service could not be accessed. This can occur if you are running Windows in safe mode, or if the Windows Installer is not correctly installed. Contact your support personnel for assistance.

well, I am not in safe mode, I guess my Windows Installer is not correctly installed, I don't know why that would be. Does anyone know how I can fix this problem.

MSDE Event ID 208/17055 (Newbie)

Hello,
We get these events logged every night, apparently when
the SQLAGENT tries to do it's backup. I'm afraid I
didn't configure MSDE on this particular server, and I
don't have any Enterprise Mgr functions on the desktop,
so I'm slightly at a loss as to how to go about resolving
this issue, being that I'm a noob when it comes to SQL.
Any advise, help or pointers would be great.
A pint goes to the first correct answer!
Andy Griggs.
Hello,
If you have another computer with Entreprise manager, you can donnect to the
msde by the network..
Marc Allard
"Andy Griggs" <andrew.griggs@.agile-it.net> a crit dans le message de
news:20dd701c459ec$940620c0$a101280a@.phx.gbl...
> Hello,
> We get these events logged every night, apparently when
> the SQLAGENT tries to do it's backup. I'm afraid I
> didn't configure MSDE on this particular server, and I
> don't have any Enterprise Mgr functions on the desktop,
> so I'm slightly at a loss as to how to go about resolving
> this issue, being that I'm a noob when it comes to SQL.
> Any advise, help or pointers would be great.
> A pint goes to the first correct answer!
> Andy Griggs.