Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: SPN for sql 2016 cluster

    Ok I set spn to VNN  but the CNN goes always to ntlm no kerberos

  • RE: SPN for sql 2016 cluster

    Ok  my two node respond to kerberos authentification but  virtualIp (VNN) cluster respond with NTLM , it's normal or i must do spn for the cluster virtual IP

  • RE: SPN for sql 2016 cluster

    For the error for Kerberos configuration manger, it's a error acces wmi  information. But i try with winrm with the same account  (domain admin) and i get infomation .

  • RE: SPN for sql 2016 cluster

    goher2000 - Wednesday, October 3, 2018 1:37 PM

    try this

    begin
    DECLARE @Domain NVARCHAR(100)
    EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE', 'SYSTEM\CurrentControlSet\services\Tcpip\Parameters', N'Domain',@Domain OUTPUT
    --SELECT Cast(SERVERPROPERTY('MachineName') as nvarchar) +...

  • RE: SPN for sql 2016 cluster

    I will resume 

    The two or many node under cluster must be have the same account for the service ans the spn bound as like

    setspn MSSQLsvc/node1.domain.com...

  • RE: SPN for sql 2016 cluster

    Yes i do this 

    the setspn -L  accountName  return the service name/server  good
    the setspn -L  serverName don't return the service  returned with the precedent command

    but bizarre  the...

Viewing 7 posts - 1 through 7 (of 7 total)