Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Installing SQL

Author  Topic 

dcarva
Posting Yak Master

140 Posts

Posted - 2006-03-29 : 15:19:52
Hello,

I have a web server that also runs SQL Server 2000. I am going to install SQL on another box to free up resources on the IIS server. Does anyone have any tips or possibly an article on the best practices for setting up SQL Server? For example, should I put transaction logs on a separate drive, what account to run the SQL services under, etc. I am looking for those types of tips. I did look on the installation articles in this site, but I don't see anything like this.

I appreciate any help,
Danny

dcarva
Posting Yak Master

140 Posts

Posted - 2006-03-30 : 16:35:28
Found a couple. Here's one I found that has some info.

http://www.windowsecurity.com/articles/Secure-Installation-Microsoft-SQL-Server-2000.html
Go to Top of Page
   

- Advertisement -