SPN and SQL Server with multiple instance names
From: Carlos Selonke (Selonke_at_discussions.microsoft.com)
Date: 02/15/05
- Next message: Next: "user database Suspect"
- Previous message: Jacco Schalkwijk: "Re: getting started with a SQL Server"
- Next in thread: John Bell: "RE: SPN and SQL Server with multiple instance names"
- Reply: John Bell: "RE: SPN and SQL Server with multiple instance names"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 09:27:01 -0800
Hello
When configuring a SPN for SQL Server using setspn.exe I should use the port
number for SQL Server as noted on the documentation about "Security Account
Delegation"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp
The syntax for SetSPN is:
setspn -A MSSQLSvc/Host:port serviceaccount
With multiple instances every instance will be running on a random TCP port
if not defined on Server Network Utility.
My question is:
What are the best practices (if there is) to configure the SPN for SQL
Server with multiple instances.
Should every instance be assigned a fixed TCP port on the Server Network
Utility and that TCP port is used when configuring the SPN?
- Next message: Next: "user database Suspect"
- Previous message: Jacco Schalkwijk: "Re: getting started with a SQL Server"
- Next in thread: John Bell: "RE: SPN and SQL Server with multiple instance names"
- Reply: John Bell: "RE: SPN and SQL Server with multiple instance names"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
