best practices for service accounts
-
I'm installing a new copy of SQL Server 2008 R2 on my Windows 7 computer. I'm at the point of Server Configuration, and I have to choose an account for each service (SQL Server Database Engine, SQL Server Analysis Services, etc).
I don't have users already for these, so I need to create them, assuming I don't just run everything under NT AUTHORITY\LOCAL SERVICE instead. What user type would you suggest? In Control Panel -> User Accounts -> Add New User wizard, I can select Standard User, Administrator, and plenty of types from Other. I assume Administrator is a bad idea, but I worry Standard User wouldn't have the required permissions. Am I going about this incorrectly, or what should I select?
-
If you were installing this on a server for production use I would recommend a domain account. But you are installing on a Windows 7 desktop so presumably this is for development or training?
Either way, the service account does not need to be an Administrator. The installation program will give it all necessary permissions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply