• Enterprise Manager for MSSQL Server 2000 used to have an option to register the instance in Active Directory - which I guess would create the SPN?

    I cannot find the same option in Management Studio, and according to BOL you should use "setspn" at the command line.

    Can anyone confirm that this is correct?

    For reference, I found the document titled "How Service Publication and Service Principal Names Work" on Microsoft's TechNet useful.