Where's my server

[GaelicFatboy]

I'm running out of possible options to install and run MSDE server on my laptop machine so I that can start building 'Project Applications'.

I've down loaded the MSDE2000A application from the internet (no version of MSDE available on CD rom, I purchased Access separatley), and ran the MSDE2000A.EXE application. This application constructed a sub-directory called "C:\MSDERelA", and within this directory was a 'setup' application which I ran using the following command line:

setup sapwd="My_Password" instancename="My_ServerName" targetdir="c:\My_SQLServer\"

Running this application, from what I have read, should install a server called "My_ServerName" in the sub-directory "c:\My_SQLServer". However if I look in this sub-directory there are no files stored in it at all.

Also if I start a new 'Project' file, the combo box that has (local) in the title has no list of local servers. I've also viewed the services under the 'manage' and the 'services' option for my computer and I cannot find a server called 'My_ServerName' or 'MSSQL$My_ServerName'. The only file I can find is 'MSSQL$MICROSOFTBCM' (anyone know what this is?).

Is someone able to tell me what I'm doing wrong?

Have I download the correct MSDE, if so have I installed it correctly?

Do I need to start the server in some way, or will it start automaticlly?

With the server running will it appear on the list in the (local) server combo box when creating a new 'Project', if not where will I find it.

Or is the binary revolution just a bad idea and we should all go back to hugging trees and living in caves.

Cheers for any help boys and girls.

D

 

[RuralGuy]

How about helping us by deleting all of the duplicate threads? As the originator of a thread, when you edit the 1st post delete the thread is one of the options. Save out moderators some work please.

 

[SQL_Hell]

hi there


What did you put in "My_ServerName" when you ran setup?

the service for MSDE (sql server) will be called MSSQL$"My_ServerName", so if you put MICROSOFTBCM as your instance name then thats the correct service

 

[GaelicFatboy]

The full syntax I used is:

setup sapwd="GaelicFatboy" instancename="SQL_Reynard" targetdir="c:\My_SQLServer\"

Cheers

D

 

[SQL_Hell]

so is there a service on your machine called MSSQL$SQL_Reynard?

have you followed all the steps in the C:\MSDERelA\ReadmeMSDE2000A.htm

Have you rebooted your machine after install?

Do you have the required permissions on your machine?

Does your machine meet the requirements for MSDE?

Have you checked the install log after install?

 

[GaelicFatboy]

I've just run an install with the log running and the log tells me "Installation Operation Failed"

I haven't looked at permissions or anything else yet, but am running out of time for today.

Any reason on the face of it why the installation would fail? My machine looks as though it meets the requirements, it's a pentium 4 with half a gig of RAM and plenty of space on the hard drive I'm also running Windows XP.

Cheers for your help.

D

 

[SQL_Hell]

http://support.microsoft.com/kb/317328

 

[GaelicFatboy]

Cheers for that I'll give it a read and try installing again

D

 

[SQL_Hell]

Hi there

Did you get it sorted?

 

[GaelicFatboy]

Not yet, but I've just been told to try running the install with my anit-virus switched off. I'll give this a go later this evening and let you know.

Cheers

D