What is the best to install SQL server on Windows 2000

[giantrunner]

Can anyone give me advise in how to install sql server.
Installing SQL server on a member server in a domain (active directory)

OR

Installing SQL server on a Domain controller in a domain

thanks

Jan

 

[icsboi]

Hi,

I installed SQL2000 and Exchange2000 on two member server.
One single processor and one double processor.
This might avoid a lot of troubles in ADS planning.

Hope this help,

Robert

 

[jplaz]

Hello, is preferable you install's it in a domain with Active Directory, since you can use the security of the directory access. The installation is normal, and soon you form the server configure acces to AD.

Regards

(Excuseme for my english i spanish)

 

[GlenJohnson]

Have to agree with the gents above, but I have one more tidbit to throw in. I installed it on our W2K server running ad, and our consulten made one change having to do with our backup. He has SQL backing itself up to the hard drive as a flat file, and our backup backups the file, not the entire sql database. Saves time and room. Good luck. Glen A. Johnson
Microsoft Certified Professional
glen@nellsgiftbox.com

"There is nothing in this world constant but inconstancy."
Jonathan Swift (1667-1745); Irish author.