"Peter van der Goes" <p_vandergoes@toadstool.u> wrote in message news:u8inweQEFHA.2540@TK2MSFTNGP09.phx.gbl...
"Barry Jon" <barryjonoconnell_spam_no@yahoo.co.uk> wrote in message news:ezW40SLEFHA.560@TK2MSFTNGP15.phx.gbl...
Thanks Peter,
I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
Edition. I then found I could not use Developer Edition with Visual Basic
.net Standard Edition and tried to reinstall MSDE. The MSDE installation seems
to go fine but when the Service Manager loads is tells me "Not Connected -
\\" no servers are in the Server drop-down and no services are listed in
the Services drop-down. I am very new to all of this and would very much
appreciate any help/advice you could offer. I then uninstalled
Developer Edition to no avail and tried again and have now reinstalled developer edition and still no joy. I am running Windows XP Pro. What am I doing wrong?
Barry Jon
I'm not sure you're doing anything wrong, but perhaps the instructions we use for classroom/lab installs of MSDE to work with Visual Studio .NET 2003 will be helpful:
<quote>
1. Before you begin, check the PC to ensure there are no remnants of prior MSDE installation attempts hanging around. The place to check is: C:\Program Files\Microsoft SQL Server. If you locate a folder named Microsoft SQL Server, delete it and its contents!
2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your MSDE download is). This step will extract the contents of the file to a designated folder. Make a note of the destination folder. You'll need it later. This step does not install MSDE (although the dialogs seem to hint that it does)!
4. Navigate to the folder you created in Step 2. In that folder, you will find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing SETUP.EXE will install MSDE.
5. To execute SETUP.EXE correctly, you must supply an instance name and a system administrator password as part of the command: i.e. the command must be:
SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"
where yourSAPassword is your actual system administrator password. This password is needed only to install MDSE, not to use it. Access to MSDE is controlled by normal "NT Security" which should allow users access based on network logon and password. It is very important the the INSTANCENAME parameter be NetSDK, as this name will enable you to generate the sample databases automatically instead of having to run SQL scripts from the command line.
6. Once installation is complete, you must reboot the PC before you will see MSDE. After the reboot, you should see the MSDE icon in SysTray.
7. You now must execute the file: ConfigSamples.exe to configure sample applications and MSDE system databases. This step will also create user databases in the following location: C:\Program Files\Microsoft SQL Server\MSSQL\Data.
</quote>
If you have trouble locating the ConfigSamples.exe, it's a small file (56k) and I can send it to your email if needed.
Hope this helps.
--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
Arrrgh!
Pay no attention to the skip in step numbers. The missing step was specific to our lab environment.
