none
SPN

    Question

  • Hi,

     

    I have installed SQL 2005 using service account and the current environment is:

     

    1. Two instances are installed on the same machine, APP1 and APP2

    2. APP1 use port 1440 and APP2 use port 1450

    3. Service account is the domain user, MYDOMAIN\APP_SRV

     

    I know I need to use setSPN to register the SPN maually. My question is should I need to create SPN for each instance?

     

    It's good if you can provide the the actual syntax to me. Thanks.

     

    boteasy.

    Sunday, January 20, 2008 4:08 PM

Answers

  • To be honest I have not performed setting Server Principal Name but I found this link which might answer your question,

    http://msdn2.microsoft.com/en-us/library/ms189585.aspx Refer this topic

    Step 3: Create an SPN for SQL Server in above mentioned link. Syntax is also given there. Following is the quote from above link,

    SQL Server only uses Kerberos if the client uses the TCP/IP protocol to connect to SQL Server. For example, if a client uses the Named Pipes protocol, Kerberos is not used. If you have multiple instances of SQL Server on a computer, you must configure a Server Principal Name (SPN) for each instance of SQL Server because each instance of SQL Server uses a unique TCP-IP port.

     

    - Deepak

    Sunday, January 20, 2008 9:42 PM
    Moderator