SQL 2K Setup Best Practices question

[wbodger]

So, what account do you use to startup the sql server service? If you use local system account then things like the Copy Database Wizard do not work because the local system account isn't the same on both servers, right? And you can't really start it under sa because that is a bad idea and sa isn't generally a domain user account. So, do you create a special domain user account and then create that as an admin login within SQL Server? I am running SQL 2K Enterprise Edition on a Windows 2003 Server. This db that I inherited is set for SQL Server & Windows security and the Startup Service Account section is all grayed out, is that how it should appear when I check the properties?

Thanks for any help you can give me.

Willie

 

[mutley1]

We use a specified domain account for the services. Not sure why your startup is greyed out, but if you go into services in windows, then you can change the MSSQLSERVER and SQLSERVERAGENT services to "start as" then specify the domain account you have set up. Dont forget to add that account into the "security" section in Enterprise manager first though with the correct roles.

HTH,

M.