July 6, 2009 at 7:31 am
I found following information by running NETSTAT command. How should I know on which port sql server serivice is running?
Proto Local Address Foreign Address State
TCP TK2HIPSQLF102:1177 tk2hipsqlf101.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:1178 tk2hipsqlf101.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc101.abc.gbb:3853 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc101.abc.gbb:25578 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc102.abc.gbb:42713 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc102.abc.gbb:64409 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc102.abc.gbb:64910 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc103.abc.gbb:12010 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc103.abc.gbb:32103 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc103.abc.gbb:32265 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc104.abc.gbb:12523 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc104.abc.gbb:32606 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc105.abc.gbb:9007 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc105.abc.gbb:29424 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc105.abc.gbb:29655 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc106.abc.gbb:7210 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipwebc106.abc.gbb:26333 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hiputlm101.abc.gbb:1044 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hiputlm101.abc.gbb:21564 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf101.abc.gbb:1763 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf101.abc.gbb:1772 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf101.abc.gbb:1773 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf101.abc.gbb:1774 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf101.abc.gbb:1776 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf101.abc.gbb:1783 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf101.abc.gbb:1787 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf101.abc.gbb:1790 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf101.abc.gbb:1791 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s TK2HIPSQLF102.abc.gbb:2331 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s TK2HIPSQLF102.abc.gbb:2998 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s TK2HIPSQLF102.abc.gbb:17094 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf103.abc.gbb:1158 ESTABLISHED
TCP TK2HIPSQLF102:ms-sql-s tk2hipsqlf103.abc.gbb:1159 ESTABLISHED
TCP TK2HIPSQLF102:1445 tk2hipsqlf103.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:1448 tk2hipsqlf103.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:2329 tk2hipsqlf101.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:2331 TK2HIPSQLF102.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:2558 tk2iasqlsm01.abc.gbb:epmap TIME_WAIT
TCP TK2HIPSQLF102:2561 tk2phxopsdc02.abc.gbb:53211 TIME_WAIT
TCP TK2HIPSQLF102:2575 tk2iamomolc01.abc.gbb:1270 TIME_WAIT
TCP TK2HIPSQLF102:2576 tk2stgmoma03.abc.gbb:1270 TIME_WAIT
TCP TK2HIPSQLF102:2581 tk2iamomolc01.abc.gbb:1270 TIME_WAIT
TCP TK2HIPSQLF102:2582 tk2stgmoma03.abc.gbb:1270 TIME_WAIT
TCP TK2HIPSQLF102:2585 tk2iasqlsm01.abc.gbb:epmap ESTABLISHED
TCP TK2HIPSQLF102:2588 tk2stgmoma03.abc.gbb:1270 TIME_WAIT
TCP TK2HIPSQLF102:2590 tk2iamomolc01.abc.gbb:1270 TIME_WAIT
TCP TK2HIPSQLF102:2591 tk2iamomolc01.abc.gbb:1270 TIME_WAIT
TCP TK2HIPSQLF102:2592 tk2stgmoma03.abc.gbb:1270 TIME_WAIT
TCP TK2HIPSQLF102:2594 tk2phxopsdc02.abc.gbb:epmap ESTABLISHED
TCP TK2HIPSQLF102:2595 tk2phxopsdc02.abc.gbb:53211 ESTABLISHED
TCP TK2HIPSQLF102:2603 tk2iamomolc01.abc.gbb:1270 TIME_WAIT
TCP TK2HIPSQLF102:2604 tk2stgmoma03.abc.gbb:1270 TIME_WAIT
TCP TK2HIPSQLF102:2998 TK2HIPSQLF102.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:3389 bayphxtsbe03.abc.gbb:52626 ESTABLISHED
TCP TK2HIPSQLF102:3906 tk2hipsqlf101.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:17094 TK2HIPSQLF102.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:25211 tk2hipsqlf101.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:41357 tk2hipsqlf103.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:41454 tk2hipsqlf101.abc.gbb:ms-sql-s ESTABLISHED
TCP TK2HIPSQLF102:51237 tk2iasqlsm01.abc.gbb:43403 ESTABLISHED
TCP TK2HIPSQLF102:1052 TK2HIPSQLF102.abc.gbb:1053 ESTABLISHED
TCP TK2HIPSQLF102:1053 TK2HIPSQLF102.abc.gbb:1052 ESTABLISHED
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
July 6, 2009 at 7:36 am
Run sqlservermanager.msc
expand sql server 2005 network configuration
select an instance, click on TCP/IP and IP Addresses tab. U can check the port on which sql server instance is running
I'm not sure how you can identify which port sql instance is running from the result of the netstat you posted.
July 6, 2009 at 7:43 am
Usually there are some ports that are "listening", look for those.
SQL Server prints this in the error log as well when it starts, so you can always check there. The Configuration Manager also shows this, and that's where you should change it.
July 6, 2009 at 9:37 am
Thanks for your prompt answers. I have drafted my questions as follows: Can anyone help me with these answers?
1. What is IP1, IP2 and IPAll in n\w configuration?
2. How to change the port for sql browser service?
3. How to determine whether this port is free any other serive is not running on this port?
4. What is Maximum and Min value of a port number?
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply