• riazjee-993186 (9/22/2015)


    Dear All,

    I am trying to setup a 2-Node SQL 2008 Cluster on Windows 2008R2 (64-bit) using the sliptstream (SP3). I am getting the following error in the end:

    The cluster resource 'SQL Server' could not be brought online. Error: The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)

    When I check the SQL Server log, I see the following:

    The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication

    Below is the output of setspn command that suggests SPN is registered:

    D:>setspn -L <Domain Name>\<Service Account Name>

    Registered ServicePrincipalNames for CN=<Service Account Name>,OU=Services Accounts,DC=<Domain Name>,DC=<Suffix of Domain Name>

    Can you please guide me how to resolve this issue?

    Regards,

    The failure to register an SPN will not stop the SQL server resource from coming online.

    Check your windows event logs and sql error log for any errors. My guess is the networkname has failed to come online, possibly due to permissions issues

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉