marrowyung
asked on
The error message when changing SQL service account
Dear all expertist,
Right now we have a test SQL server that we need to change the all SQL service to use a service acount from SQL configuration manager.
We found that we can only change some of the SQL service but not all, we can't change SQL server Integration Service and SQL server browser.
This server is also the DC, when we do the same thing on another server which is not the DC, everything is fine.
Please the attachment for more information, it say "The group name could not be found. [0x800708ac]".
Any ideas?
SQL-service-account.jpg
Right now we have a test SQL server that we need to change the all SQL service to use a service acount from SQL configuration manager.
We found that we can only change some of the SQL service but not all, we can't change SQL server Integration Service and SQL server browser.
This server is also the DC, when we do the same thing on another server which is not the DC, everything is fine.
Please the attachment for more information, it say "The group name could not be found. [0x800708ac]".
Any ideas?
SQL-service-account.jpg
ASKER
ONly SQL browser and then full text service has this kind of problem on that server only !
ASKER
That server is also a Virutal machine.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ryanmccauley,
I read that link before I don't know what means "it was suggested that the SQL Server Browser Service be run under the LocalSystem account instead of the NetworkService account."
this is MIcrosoft recommended that, since SQL server 2005, the change of service account can't do it directly from service console, is it the Services admin tool you talking about ?
I read that link before I don't know what means "it was suggested that the SQL Server Browser Service be run under the LocalSystem account instead of the NetworkService account."
this is MIcrosoft recommended that, since SQL server 2005, the change of service account can't do it directly from service console, is it the Services admin tool you talking about ?
ASKER
dtodd,
Right now we are trying to change all SQL service to run under the same Windows account. We just did it on production and it all working well but just one staging machine has that error.
We tried that before on the production DR machine about the same thing but it seems it is the permissino thing, however, no proof on this.
Right now we are trying to change all SQL service to run under the same Windows account. We just did it on production and it all working well but just one staging machine has that error.
We tried that before on the production DR machine about the same thing but it seems it is the permissino thing, however, no proof on this.
ASKER
mark_wills,
Sorry I am busying on something else.
"to check, if you change to LocalSystem account does it then work ?" Yes, once I change it back to localsystem, it just work back.
"I recently had a problem with SSIS (or more precisely launching Information Services from SSMS) and had to go through configuration manager and add account groups etc... But that was a slightly different error message."
agree ! before I do it on production platform, some stupid system administrator remove my local administrator right on production DR machine and I can't even change account, the error message is different.
But as the doc said, only SQL server and SQL agent is need to change account before the SQL mirror can be setup without cert, so I just ignore it. BUT cna't see why only the staging platform has problem.
"But when it happened I did read very carefully through : http://msdn.microsoft.com/en-us/library/ms143504.aspx#Changing_Accounts and found it quite interesting because of the changes for 2008 R2 and 2012 (if you are using them)."
We are stilling using SQL 2005 SP2.
OS is Windows 2003 standard.
Sorry I am busying on something else.
"to check, if you change to LocalSystem account does it then work ?" Yes, once I change it back to localsystem, it just work back.
"I recently had a problem with SSIS (or more precisely launching Information Services from SSMS) and had to go through configuration manager and add account groups etc... But that was a slightly different error message."
agree ! before I do it on production platform, some stupid system administrator remove my local administrator right on production DR machine and I can't even change account, the error message is different.
But as the doc said, only SQL server and SQL agent is need to change account before the SQL mirror can be setup without cert, so I just ignore it. BUT cna't see why only the staging platform has problem.
"But when it happened I did read very carefully through : http://msdn.microsoft.com/en-us/library/ms143504.aspx#Changing_Accounts and found it quite interesting because of the changes for 2008 R2 and 2012 (if you are using them)."
We are stilling using SQL 2005 SP2.
OS is Windows 2003 standard.
Well, it does sound very much like a permissions issue - possibly some file on disk in a folder used by SSIS where you new account cannot get full access - and that's why it works if you change to localsystem (which has all the correct permissions to access those files / folders).
ASKER
I am not changing any thing related to the SSIS, I am talking about the SQL browser service.
ASKER
it is hard to solve anyway and give you all mark for helping first, please keep helping to gather more information.
ASKER
This link really said that, http://support.microsoft.com/kb/283811, we should use SQL configuration manger to assign account.
ASKER
The group name could not be found. [0x800708ac]