July 29, 2004 at 11:48 am
We inherited a system with our production SQL Server 7.0 running on an NT machine which is also our PDC. For this reason, the service accounts for SQL Server and SQL Server Agent need to be members of the Domain\Administrators group. Does this hold true if the server were running on a BDC instead of a PDC?
July 29, 2004 at 2:36 pm
They do not need to be administrators. It makes things easier, but you can set permissions to use any local or domain account.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811
August 15, 2004 at 7:40 am
take care that you might face some problem if you make SQL Server and SQL Server Agebt work on Local account ...
it is recommended to set it to a Domain account (and must be from the adminstarors Group)
I hope this help u
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply