June 8, 2006 at 3:11 pm
Does anyone know off the top of their head what local permissions a domain user must have to get the MSSQLSERVER service to run as that user?
The Redneck DBA
June 12, 2006 at 8:00 am
This was removed by the editor as SPAM
June 12, 2006 at 10:18 am
While there is a list of permissions, it is recommended to change the Startup account in Enterprise manager for SQL Server 2000 and Configuration Manager in 2005. This is because Enterprise manager and Configuration manager will set the minimal permissions for you!
BOL Says: "Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings. Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. If the service cannot access the SQL Server portion of the registry the service may not start properly."
The required Windows right is to "Run as a Service" but I think both tools when setting permissions will grant this right to the account too.
Read the following articles in SQL Server 2005 Books Online:
SQL Server Configuration Manager
Setting Up Windows Service Accounts
Service Account
Regards,Yelena Varsha
June 14, 2006 at 11:20 am
Here is the official word from Microsoft:
However, I would agree with Yelena to do this through EM or SSMS. As long as you have sufficient rights, it'll make sure the service account gets the rights and permissions it needs.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply