Tuesday, August 21, 2012

SQL Server 2012 Failover cluster error (Windows Event ID 1119)

Recently I installed SQL Server 2012 RTM on a Windows failover cluster. After installation when I tried to fail over SQL server resources from N1 to N2 I got following error
Cluster network name resource 'SQL Network Name (MyServer)' failed to register DNS name 'MyServer.' over adapter 'Local Area Connection*' for the following reason:  'DNS server failure.'

I found the event ID and resolution on technet

But it was nothing to do with the solution mentioned on technet article.

My problem was SQL server service account was not part of the Local Administrators group. (Which I should have done before installing…dumb!!)
So here is how you add SQL service account to local
1)      Go to Start à Administrative Tools à Server Manager
2)      Expand Configuration
3)      Expand Local Users and Groups
4)      Select Groups
5)      Double click on Administrators
6)      Click on Add button
7)      Enter SQL Service account (Account under which SQL services are running)
8)      Click OK
After doing this I was able to failover SQL Server to passive node

No comments:

Post a Comment