How to Install MSDE (Sql Server 2000 Desktop)

While not cutting edge OO programming, I’ve instructed people so many times how to do this, that I decided to add it to the blog.
 
MSDE is a "free" and "lite" version of Sql Server 2000.  It has a few articial govenors in it, and a few features disabled.  However, for most developers, it is a great way to get the Sql Server 2000 engine.
The great thing about it, is that any code (tsql) written for MSDE will work on Sql Server 2000.  It is much much better than going from Access to Sql Server.
 
 

Go Here to get to the download. Or try www.microsoft.com/sql and search for "MSDE".

 

You will download the file.  Once downloaded, you will run the exe and it will decompress the files.

Let’s assume you extract the files to c:\wutemp\msde\

 

The trick with the install is that running the "setup.exe" file (in c:\wutemp\msde\ folder) won’t really do anything.

The program installs from the command line prompt.  Here are some short cuts.

 

Inside the c:\wutemp\msde\ folder, create 2 new files.

InstallMSDEWithMyParameters.bat

MyParameters.INI

 

The contents of InstallMSDEWithMyParameters.bat will be:

setup /settings "MyParameters.ini" SAPWD="sapassword" /L*v C:/MSDELog.log

The contents of MyParameters.ini will be:

[Options]
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL

 

You can read more about the options in the ReadmeMSDE2000A.htm file (which is a part of the extraction process)

 

Now, double click the InstallMSDEWithMyParameters.bat file, and it will be off to the races.

You’ll notice that your sa password will be "sapassword".  You can alter this if you’d like, but make it something you can remember, because you’re dead in the water without it.

 

I’d reboot after the install, so the MSSQLSERVER services will start up.

 

Now you have a functional, local, legal development server.

 

You main tool of trade will be osql.exe.  Google it, and you’ll find more info.

While MSDE is free, Microsoft makes you jump thru some hoops to use it.  They really want you to buy the full version.  But the hoops are much better than using Access for any decent sized relational database.

 

 

Advertisements
This entry was posted in Software Development. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s