Running SQL server with a domain account
Posted on 2010-11-30
I've been running MSSQL2005 on a 2003 server with the main SQL service using the main Domain administrator acount and password.
Not the best practice so I've created a new AD user account for this purpose, however how do I then assign the appropriate permissions to this new account for the service to run?
I assumed there would be a local user group on the server that is running sql that I would make the new AD user a member of but I can't see an appropriate group (there are several SQL groups but not one that works, I get error 17058)
If I run the SQL service using Local System account then it runs fine but how secure is this?