-
how to do i check the port sql server is listening to
when im doing telnet to my server ip & the default port for sql 1433 its given me error " could notopen port 1433 for connection". Can you please tell how do i check which port is my sql instance listening to.
-
You can find that out from SQL Server Error Log. You should see a line like
SQL server listening on 127.0.0.1: 1433.
You can also go to the server and run Server Network Utility and see if TCP IP port is configured or left default. Or you can check the registry entry
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\ MSSQLServer\SuperSocketNetlib\Tcp
-
Or look at sql server network utility on that server.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|