Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Zoroaster
Aged Yak Warrior
702 Posts |
 Posted - 2007-09-13 : 11:24:32
|
I have recently installed 2005 Standard and 2005 Reporting Services (on a separate server), today we built a service account for the SQL services in Active Directory. I planned to use SQL Configuration tools to change the account but it fails with the message:'No mapping between account names and security IDs was done'I ended up going through and following the manual steps outlined in KB article 283811 - http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811But I am baffled and concerned as to why it failed. Any advice?
Future guru in the making. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-13 : 12:16:53
|
| interesting.. i've never used sscm to do this but isn't there a log where you have more error details? or the event viewer?--------------------keeping it simple... |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-09-13 : 12:19:44
|
| Did you add the service account to the server as a local admin?Does the service account have rights in the SQL Server security as sysadmin?PS: If anyone is interested in a SQL Server job in Connecticut with excellent pay please send your resume to ValterBorges@msn.com |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-13 : 12:21:32
|
| what's interesting is that the link claims that all those you've mentioned will be done automatically, no script to run, packaged in one neat little box--------------------keeping it simple... |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-13 : 12:29:24
|
quote:
Originally posted by ValterBorges
Did you add the service account to the server as a local admin?Does the service account have rights in the SQL Server security as sysadmin?PS: If anyone is interested in a SQL Server job in Connecticut with excellent pay please send your resume to ValterBorges@msn.com
Yes, I did all of the above. I am not sure what the cause is, everything is working correctly from what I can tell but it is weird that it didn't let me use the config manager to do it. I read articles where others had this problem but without any solutions.
Future guru in the making. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-13 : 12:30:36
|
quote:
Originally posted by jen
what's interesting is that the link claims that all those you've mentioned will be done automatically, no script to run, packaged in one neat little box--------------------keeping it simple...
That's right, if it works that is!
Future guru in the making. |
|
|
|
|
|
|
SQL Server Service Account questions