December 17, 2008 at 11:41 am
As usual, I should have read further before installing. With 2008 it is suggested that you create/use a normal (domain if needed) user account for services, and let the installer set the appropriate security for the accounts.
Instead, I just used Local System, thinking I'd come back and fix them after the fact. Now I have no idea what rights/permissions to put on an account (besides run as service) to duplicate what the installer would have done.
I really don't want to have to start over again. Is there a list available anywhere that lists what changes I'd need to make, to get the equivalent of what the installer does for the service accounts?
JimInFL
December 17, 2008 at 12:07 pm
Launch SQL Server Configuration Manager and change it there. That should set all appropriate permissions as needed.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 17, 2008 at 12:59 pm
Just remember to add the ability for the account to lock pages in memory if you are using a beefy box.
December 17, 2008 at 2:30 pm
Thanks guys. So I understand that if I go ahead and set up the normal Windows domain accounts, then use Sql Configuration Manager to use them as the service accounts, Config Mgr will take care of assigning proper security for them, without needing my intervention - correct ?
JimInFl
December 17, 2008 at 2:38 pm
That is what is supposed to happen. 😉
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply