November 5, 2009 at 5:22 pm
Hi
I have a problem where I cannot create/edit maintenance plans on an existing install of SQLServer 2005 SP1. I delete exisitng maint'plans manually to stop them erroring in logs and replaced with normal Agent jobs.
I cannot create any new plans; result in mscorlib exception.
I've been told this machine was set as a domain controller it isn't now.
If I try and run any of the SQL services e.g. SQLAgent as LocalSystem I get error "No mapping between account names and security IDs was done". I THINK this is because in SQL Server logins I have the 3 service logins in this format:
DOMAIN_NAME\SQLServer2005MSFTEUser$COMP_NAME$MSSQLSERVER.
If I try and get an SID value for this user it understandbly fails - this domain doesn't exist..
The guys have tried putting SP3 on - but it failed (don't know error) - but I guess it comes from the fact that DOMAIN_NAME\SQLServer2005MSFTEUser$COMP_NAME$MSSQLSERVER isn't valid.
see http://support.microsoft.com/kb/925976.
What can I do to get it to run as local system account? Is it worth running reg fix in article afterall I do not have a user COMP_NAME\SQLServer2005MSFTEUser$COMP_NAME$MSSQLSERVER.
Or am I barking up the wrong tree.
Thanks
December 7, 2009 at 8:50 pm
I think you are probably barking up the wrong tree with those logins..
Can you create maintenance plans from another server? Also I don't userstand the statement "Computer not domain controller anymore".
CEWII
December 8, 2009 at 10:15 pm
If I am understanding your predicament correctly, your SQL server was also a Domain Controller. You have recently demoted that Domain controller to a member server.
Prior to demoting the Domain controller, did you promote another server to be the domain controller? If so, you can probably correct the problem by rejoining your SQL server to the domain. If not, the domain accounts are no longer valid. Another possibility is that you demoted the domain controller prior to adequate time for AD to synchronize. In the latter scenario, you may have to recreate the service accounts.
Query AD (if it exists) and verify that your service accounts are present.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 8, 2009 at 10:20 pm
double post
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply