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.
| Author |
Topic |
|
probani
Starting Member
2 Posts |
 Posted - 2005-06-02 : 07:27:17
|
| Hello there,i'm having problems starting sql services with domain account user. I have created domain user for instance domain_name\startsql and I'm trying to start sql services in all the servers in the network through this account. The idea is to use this user only for starting sql services and for sql mail as well. Server itself will start with another user let's say domain_name\admin.hq, and sql services with this mentioned account above. The thing is that I don't want to give local admin permission to this user. So I've tried to give permissions to this user in the registry, in sql server folders and local policies as well. I gave all the permissions below:-to MSSQL folder (and to the .mdf, .ndf, .ldf files inside) and to the registry keys at and under :HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer.and HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQLServer. + SQLServerAgentHKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Perflib.---------------------------------AND"Logon as a service" and the "Act as part of the operating system" permissions.But STILL NOT WORKING, so can somebody tell me why is this happening, did forgot to give additional permissions for this user in the machine or ...?The server that I'm using is Windows server 2000 and sql server 2000 developer's edition.Thanks a lot,Probani. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-06-02 : 09:49:34
|
| Does the domain user have write permissions to the data directory ?DamianIta erat quando hic adveni. |
 |
|
|
|
|
|
starting sql services with domain user