There is a Windows 2000 Server Domain and there are two users. User a and User b.
Now on machine1 User A is an Administrator and there is SQL Server installed.
But User B is not an administrator on the machine1.
I want the SQL Server Service to run under the User B account.
What all permissions should I give for the User B on machine1.
But the problem is that I cannot give the User B as an Administrator on the machine1.
Without giving the Admin permission on Machine1 how can I make the SQL Service to run under the UserB.
I have given the below mentioned permissions....
Requirements for Domain User Account
All domain user accounts must have permission to:
Access and change the SQL Server directory (\Program Files\Microsoft SQL Server\Mssql).
Access and change the .mdf, .ndf, and .ldf database files.
Log on as a service.
Read and write registry keys at and under:
-or- for any named instance: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server.
-or- for any named instance: HKEY_LOCAL_MACHINE\System\CurrentControlset\Servic es\MSSQL$Instancename.
In addition, a domain user account must be able to read and write corresponding registry keys for these services: SQLAgent$InstanceName, MSSearch, and MSDTC.