Installing local copy of SQL server 2000

[chuckster123]

Hi everyone,

Are there a instructions somewhere on the net on how to install a local sql server on a client PC.

I need it for testing, so I don't mess up the live stuff, lol

But I have all sorts of problems like access denied, server does not exist, server not running. Any simple walk through out there ?

Any help is greatly appreciated.
Thanks

 

[twisty]

you cant run enterprise edition on anything but a server. if you try to load it on a workstation, it errors out. you need to try to find a personal edition version of the server to load, that way you can do your testing. but you cant use that in a plant environment, its for personal use and learning only.

 

[johnwm]

MSDE is the free version of MSSQL. You can read about it (amd download it) here:

http://www.microsoft.com/sql/msde/downloads/download.mspx

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk