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 |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
 Posted - 2008-09-25 : 12:42:48
|
| Does anyone know an easy way to find the port number that a SQL Server instance is using in SQL Server 2000?CODO ERGO SUM |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-25 : 13:19:09
|
| Haven't used SQL 2000 for so long. I think you can find in Network Utility. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-09-25 : 13:59:02
|
| I just need to be able to find the port number when confronted with an unknown SQL Server that I only have access to at the Windows level.I was hoping for some really easy to use utility, but anything that works will do.CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-09-25 : 14:02:17
|
| ... I know the URL that I pasted doesn't seem like it will help, but it explains where to find the port in the registry if you don't have the server network utility installed.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-09-25 : 14:49:10
|
Thanks. I tried both, and they both look good.It's shocking how often I am confronted with a SQL Server I never heard of before, considering how many years I have been at this company and that I am nominally responsible for all of them.  CODO ERGO SUM |
|
|
|
|
|
|
Find Port in SQL Server 2000