December 6, 2012 at 5:12 pm
hi guys, i have not changed anything in my sql server configuration, i know as a default the sql port for an instance is 1433 but when i run master..xp_cmdshell 'netstat -ano' , i don't see that port anywhere, does that mean the ports SQL is running under was changed? What i need to confirm is what ports SQL uses for 1 machine.
December 6, 2012 at 5:28 pm
netstat -abn (with elevated command prompt) will show all ports in use by all applications on the system.
or
Launch SQL Server Configuration Manager. Go to SQL Server Network Configuration and look the protocols for <your sql instance name>, then tcp/ip properties and the IP address tab. (This shows the port in use)
good luck!
December 6, 2012 at 6:11 pm
thanks for prompt answer, when i go to SQL Server Network Configuration , IP address Tab, under IPALL:
TCPDynamicPort 53244
TCP Port is blank
when i run netstat -abn
TCP 10.78.100.88:53244
does that mean the port sql has is the default 1433?
I need to add the port number to open ACLs on the network so my server can communicate to this sql instance.
December 6, 2012 at 6:36 pm
Is it a default instance or is it a named instance?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 6, 2012 at 6:45 pm
it is a named instance
December 6, 2012 at 6:47 pm
Then open up for the dynamic port you listed.
Also, open for TCP port 1433.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 6, 2012 at 6:56 pm
i am sorry now i am confused why for both?, are the tcp port and dynamic port different?
December 6, 2012 at 7:23 pm
Best would be to either change it to a static port or open a range.
On occasion a Named instance can use port 1433. But it can also use a port from the dynamic range. This is why many will assign a static port to SQL Server instead of allowing it to be dynamic.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 6, 2012 at 7:27 pm
i understand.. Thank you!
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply