February 26, 2008 at 4:30 pm
I have been researching this problem for several days and have not come up with a solution. I tried to install SQL Server 2005 on a new server. In the past, we have run SQL under admin accounts. I have read the best practices and decided to set up separate accounts for sql server and sql agent to run under. I could not get SQL installed using these accounts, so I decided to install using the admin account and change it in the SQL configuration manager.
When I try to change the account that the service logs on to, I get an error that says 'Cannot find object or property'. I can change it back to the admin account and it starts fine. I thought that SQL took care of all the permissions, but could there be something missing? I also get errors in the event viewer saying that 'An error occurred during decryption'.
Any ideas? I know this is best practices, but in reality do most people just run under an admin account? I would really feel better if I could get this to work.
Thanks,
Kim
February 26, 2008 at 7:07 pm
I've installed SQL Server 2005 on clusters & standalone servers with domain user accounts for the services with no issues. Create the accounts first, run SQL Server setup & when you get to the section for setting the accounts, do so. No need for the accounts to be domain or local admins. SQL Server sets the permissions itself.
Any additional permissions required afterwards, (e.g. NTFS/share permissions for log shipping or replication) you set manually.
Naturally, the account you use to run setup.exe should be a local admin at least.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
February 27, 2008 at 6:55 am
I have tried the install that way. I don't know why it isn't working. Now, though, SQL is already installed with an admin account and I cannot change it. Has anyone else gotten this error while changing the service accounts?
February 27, 2008 at 7:13 am
Just something that you can check, See if the Domain of the user is assigned to the groups that the SQL Server creates when it is being Installed.
-Roy
February 27, 2008 at 9:00 am
Does the windows user which user are trying to use as a service account has got necessary privileges to work like logon as service rights, registry permissions, folder permissions, etc. this might be a problem. Also one thing that i have found was that yo have to give the user name along with th server like servername\sqlservice so that sql server identifies it eassily.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply