Named Instance Port numbers / Kerberos Authentication

Question

Post reply

Named Instance Port numbers / Kerberos Authentication

dave-dj

SSChampion

Points: 11297
More actions
April 8, 2010 at 3:52 am

#213499

I'm setting up kerberos authentication between our Report server and a number of SQL servers.
One of our servers, has 3 Named Instances of SQL Server, which I have found out I need to set up SPN's for with the instance port number. Currently, the port numbers are dynamic.
My question is: How do I know what port number to use? Or do I just randomly select one?
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

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

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

I suggest that you use fixed port numbers and set SPNs for those ports.

-- Gianluca Sartori

dave-dj SSChampion Points: 11297 More actions · Answer 2

Thanks,

but I need to what port numbers I can use.

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

Oh, I see. Sorry, I misunderstood your question.:blush:

Well, I don't know if there's a best practice for choosing a port number. I can only tell you that the port numbers I usually choose are between 1500 and 1600, but if there's a better recommendation I'm all ears.

-- Gianluca Sartori

dave-dj SSChampion Points: 11297 More actions · Answer 4

So it is a case of randomly coming up with a port number then.

Apart from the odd bit of software, like SQL default and http services, I not sure what other ports are used and as this need to be done on a production system, I don't want to go breaking anything.

Thanks Gainluca

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

You could pick the port currently in use by the instance.

If you want to know the port numbers currently in use by the system, use this:

NETSTAT -anp TCP

-- Gianluca Sartori

dave-dj SSChampion Points: 11297 More actions · Answer 6

excellent 😀

that'll take the guess work out of it.

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)