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.
| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-07-12 : 07:42:06
|
| I have access to the default instance of a SQL Server ..... I have access to the QA only .. by reading the registry through the QA I get to knw that there are additional 4 more instances on the Server ..... is is possible to get the port on which they are listening using the QA ....I knw that we can go to the servers network utility & see it there in the TCP /IP ... but i dont have access to that , neither do i have access to the error logs that tell me , on which port is SQL Server listening to Can someone help |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-12 : 08:06:08
|
| Ask whoever set up the servers if they have allocated a static port.By default sql server will allocate a dynamic port when it starts up - the default will get 1433.Maybe the TcpPort or TcpDynamicPorts under SuperSOcketNetLib\Tcp gives it?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQL Server Port.... (Named