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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-13 : 17:03:19
|
| Kim writes "We have way too many SQL servers to count. I am trying to audit every server to report the port in which SQL is listening on. I am able to utilize xp_regread, but that does not work for SQL 7.0 as I do not find the port setting in the registry for SQL (windows I can, but they are not neccessarily the same) It is not held in the system tables either. I need some input on this matter, can you help?" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2001-12-13 : 17:11:32
|
| Have you tried the utility called SQLPing?? You can find it at www.sqlsecurity.com, try it. The only problem is if you have routers with access lists or firewalls with filters between yourself and the SQL-servers. |
 |
|
|
|
|
|
TCP Port