I quick look in the event log :
Event ID : 17058
initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).
I checked the security of my folders (where the instance is installed), no problem.
What is important at this point, is that I just promoted my server as a domain controller. Beginning of my problem.
Second symptom : changing the service account fails with error 0x80070534
I went in my SQL Configuration editor in order to change the service account information.
0x80070534 No mapping between account names and security IDs was done.Impossible to change credentials.
I also tried ti change the account directly in the windows Service MMC, no way to start the service as local account or even Administrator.
The following article gave the final clue : http://serverfault.com/questions/24484/sql-server-2005-on-2008-dc-cannot-change-service-user
After a few googling, it cames that my problem is a windows SID problem. After promoting my server, some SID changed, and my server was unable start using the old credentials.
To solve this problem, go to
Regedit
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLxxx.Instance\Setup
locate SQLGroup String. It contains the SID which has changed.
locate AGTGroup String. It contains the correct SID.
Just copy the content of the AGTGroup string in the SQLGroup string.
AGTGroup = S-1-5-21-3474037693-4059913137-208468936-1004
SQLGroup = S-1-5-21-3474037693-4059913137-208468936-1003
In order to be sure of the SID of the group, you can launch getsid.
This article may help you find the correct group SID : http://blogs.msdn.com/b/jorgepc/archive/2009/11/19/the-domain-group-cannot-be-validated-for-the-service-sql-server-sql-server-2005-cluster-setup-error.aspx
You can use this tool to get SQLGroup SID : https://technet.microsoft.com/en-us/sysinternals/bb897417.aspx
Hope this article will help you
No comments:
Post a Comment