Where's my server?

[GaelicFatboy]

I've just started down the rocky road of stepping up to using Access Projects and installing MSDE as my server. However, I'm having some trouble in getting up and running. In short I cannot find the MSDE server in order to start it running.

I've installed the MSDE server on my laptop for now using the following command line:

C:\sql2ksp3\MSDE\setup.exe SAPWD="My_Password"

However, first time I ran this command line I forgot to put the quotes around My_Password, would this be causing the problem?

When I start the SQL Server Manager the MSDE server simply doesn't appear in the server combobox and likewise the services combobox is also empty. I've tried typing the default server name "MSSQLSERVER" but this doesn't work either.

Should I have added the INSTANCENAME parameter, if so which of the follow formates should I use as the syntax?

INSTANCENAME=My_ServerName

INSTANCENAME="My_ServerName"

INSTANCENAME=<My_ServerName>

Hope someone can get me running, cheers for now.

D

 

[SQL_Hell]

Hi there,


Installing MSDE by using sql2ksp3, is not installing MSDE you are only installing Service pack 3 for MSDE.

Install MSDE before you service pack it