User for MSSQL 2008 Service Accounts
- by Campo
I want to create a Domain User that runs the SQL Service Accounts.
The reason for this is that I have setup mirroring and MS recommends having the same user (a domain user account) running the services across all the the computers in the configuration to ensure mirroring will work properly. Right now in the test environment I just had them run under my user for simplicity. But now that I know what I am doing I would like to test the configuration more accurately.
I am also aware that it makes things much simpler if this user is an administrator.
My question is.
Should I just create a simple user SQLSERVICEUSER and make it an administrator? Seems a little insecure to me.
Anyone have a more elegant solution?