Port Numbers - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Port Numbers

Author

Topic

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-06-02 : 09:06:27

Hi Gurus,

Iwant to know PORT number of B on A server.
Iam following the following process to get B PORT number.

1) Loging to server A.
2)Opened SQL Server Configuration Manager.
3)Opened SQL Server 2005 Network Configuration.
4)Opened TCP\IP properties of Protocol for B.
5)On that opened IP Address TAB
6)Got PORT number from TCP Dynamic Ports

Am i going n right way.
If not please advice me the right way to get port numbers.

Thanks,
ServerTeam

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-02 : 22:47:42

You can find port number in sql server log.

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-06-03 : 10:03:12

if you don't mind can you please me in simple words..

Thanks,
ServerTeam

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-06-03 : 10:50:34

where can i view SQL Server log.

Thanks,
ServerTeam

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-03 : 11:57:37

xp_readerrorlog on Master DB

Manoj
MCP, MCTS

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-03 : 12:06:28

OR you are talking about SQL logs

Here you go...
Binn folder and some times in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

Manoj
MCP, MCTS

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-03 : 16:10:51

>> where can i view SQL Server log

Under management -> sql server logs in ssms.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-06-03 : 18:11:13

Use this procedure to find the port used by SQL Server 2005 instance:
1. Launch the Server Configuration manager:
2. Expand the Network Configuration node and find named instance in the list
3. Right click on "TCP/IP" under "protocol name" and select "Properties" from the pop-up menu.
4. On the Properties screen on the "Protocol" tab, find the "Listen All" field, and note if it is "Yes" or "No".
5. Click on the "IP Addresses" tab.
6. If the "Listen All" field on the "Protocol" tab is "Yes", then the port number is in the "IPAll" section.
7. If the "Listen All" field on the "Protocol" tab is "No", then it is in one of the other two sections, depending the IP Address of the named instance is. Find the IP Address (use ping if you have to) and use the port number assigned to it.

CODO ERGO SUM

ServerTeam
Yak Posting Veteran

83 Posts

Posted - 2008-06-04 : 08:33:40

Thanks Michael.

Iam on the right path.After seeing your post i fixed with this :)

Thanks,
ServerTeam

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources