December 13, 2011 at 5:47 pm
I've a sql 2005 instance installed on my dev env and i noticed that we have builtInAminstrator with sys admin rights. I need to remove sysadmin from builtinAdmin but when i double click and remove the sysadmin from that login , it hides every login and shows only BuliltInadmin and SA and if i try to create new login i get an error message that i dont have rights to creat one. So i had to login with SA and change back the permission to Sysadmin for BuiltInAdmin login...All sql services are running under local group …need to change this one as well…Could you please help me
December 13, 2011 at 7:25 pm
First, you need to add your account to SQL Server and set it up as sysadmin. Then, you can remove the sysadmin right from BUILTIN\Administrators.
Right now, you are authenticated through that group and removing sysadmin removes your sysadmin rights.
As for changing the service account - use SQL Server Configuration Manager. That should add the service account to the appropriate groups and set the appropriate rights for running SQL Server.
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 13, 2011 at 8:21 pm
Thank you for your quick reply and As you know that the service account as currently it is running as local and need to use one of the accounts that is used on another server for service account but the only issue is i dont have the password for it and when i enter any other password ..i am getting message that the network password is not correct...now the question i have is....Do i need to get the same password they are using on other server or is there any way i can change the password for this user here on this server?
December 13, 2011 at 8:50 pm
You need the password. It is a domain account and you cannot change it without affecting the other system.
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 13, 2011 at 9:18 pm
Yes as Jeffrey has mentioned, you will have to have that password and use it here on this server. If you cannot find the pwd for the service account, you have to get another service account setup for this server.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2011 at 7:09 am
Thank you guys for your quick reply... As you know that i removed the SA permission from builtInAdmin login but now the sql agent services are not running...Please help
December 14, 2011 at 9:00 am
You are doing things backwards. Don't manage the admins this way.
If you don't need or want BuiltIn\Administrators as admins, then remove that group from the logins. However, before you do this, create another AD group, and add them as logins and sysadmins.
If you want to run SQL Server under a domain service account, create a new account for this instance. Don't re-use the account from another machine. It's a place where you can create an admin issue. Use separate accounts for the database engine, and a separate account for SQL Agent.
Change your service accounts, only using SQL Server Configuration Manager. This will ensure permissions are correct. If your SQL Agent is not starting, what is the error? Check the Windows Event logs for the error. It is likely permissions or password, but you need to know which to fix it.
December 14, 2011 at 8:31 pm
Thank you so much.. I could solve this issue by following the steps you guys suggested but now when i try to change the sql server service account i am getting below error. Currently sql service is running through local account and i need to change it to domain account. I have domain account username and password and i was able to change the account for all other service ie. agent, broswer etc. but not for the sql server service acccount
cannot find object or property 0x80092004
December 15, 2011 at 7:05 am
Which steps produced the error? If this comes from Configuration Manager than you may have something broken or corrupt in your installation.
Do you have encryption set? Does this apply? http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/b308d9c8-6aba-4b3b-9b32-f919816d1be2
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply