Post reply

KERBEROS

  • February 2, 2009 at 11:44 am

    #936625

    its the server name and i have only 1 instance on that server. Yes it is named i i think.

  • February 2, 2009 at 1:19 pm

    #936707

    If it's a named instance, then by default it does dynamic port allocation. When SQL Server starts up, if something is listening on that port, it'll choose a different one. Since SPNs are configured per port, this is bad. It means your SPN is invalid and Kerberos authentication doesn't happen. Check to see if that's the case. If it is, find out what port it was using by listing the SPN. Then statically configure the port to what your SPN has registered.

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 46 through 46 (of 46 total)

You must be logged in to reply to this topic. Login to reply