MSDE 2000 install
Today I was installing MSDE 2000 Release A on my machine, since our company do not allow us to install SQL Server on our work stations.
I noticed MSDE 2000 Release A does not come with the two highly mentioned sample databases "NorthWind" and "Pubs". But luckily if you have VS.NET 2003, you allready have the sql files for these two databases, you need to run these files against your MSDE instance using osql utility. The following is the sample command to install these two data bases
C:\>osql -E -S (local)\VSDOTNET -i instnwnd.sql
Also, sometimes it gets tricky installing MSDE on our machine. For anyone's information, you should use the following procedure to install MSDE 2000
Open the setup.ini file in ur C:\MSDERelA
Add the lines under the [options]
INSTANCENAME=VSDOTNET
DISABLENETWORKPROTOCOLS=1
SAPWD=urPassword
After saving the setuo.ini file run the setup with these arguments
setup /L*v C:/MSDELog.log
Oh yeah, one more tricky thing is, MSDE setup at times do not notify you that, set up is completed. So, if you are unsure about it, restart the computer and see if the Service Manager starts in the system tray.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
Comments