SQL Server Performance

SQL N/W name failed to go online

Discussion in 'SQL Server 2005 Clustering' started by satya.sqldba, Apr 29, 2008.

  1. satya.sqldba New Member

    I have finished the install of SQL 2k5 in a cluster and the resources are not going online with the below message in the event viewer:
    Cluster resource 'SQL Network Name (VMSPAP1111CAB)' failed to go online because its associated computer account (VMSPAP1111CAB) exists in Active Directory and the Kerberos authentication is not enabled for the resource. Client applications that are using Kerberos based authentication (either directly or through the Negotiate security package) will fail to authenticate when contacting a service by this network name.

    To bring the resource online, either enable Kerberos authentication or delete the computer account.
    Any suggestions on what has to be corrected?

  2. satya Moderator

  3. satya.sqldba New Member

    Thanks Satya
    While executing the command

    setspn -A MSSQLSvc/<FQDN>:<Port> <SQL_Service_Account>
    should the FQDN have the virtual name or the node name on which the install is being carried out?

Share This Page