September 14, 2005 at 3:18 pm
Hi All,
Can any body say the Port number on windows server system where the SQL server is running ?
Thanks in Advance
Suersh
September 14, 2005 at 4:31 pm
September 15, 2005 at 6:04 am
That is the default port - you do not have to configure it for 1433. Default installations of SQL Server monitor TCP port 1433 and UDP port 1434. There are a couple ways to check which port was used for your configuration.
1) You can use the server network utility to see what it is configured for in your installation.
2) You can also check the port number an instance of SQL Server is using by looking in the error log for the specific instance. You should see an entry in the error log that looks like this:
SQL server listening on 127.0.0.1: 1362.
The four-digit number after the colon is the port that SQL Server is listening on for the IP address, which is specified to the left of the colon.
3) Alternatively, you can check the port number an instance of SQL Server is using by looking in the registry. Specific paths to registry keys vary based on how you've installed and upgraded SQL Server, but you should find a key similar to the following:
HKLM\software\microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp\
where InstanceName is the instance name of the SQL Server you're using. The key will have an entry called TcpPort, which contains the port number the instance is using.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply