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 |
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
 Posted - 2004-12-03 : 14:09:45
|
Hey guys... I have been auditing the servers under my control and have found some security issues, How can I get a recordset of all of my Sql Server instances running in my domain... I can see the information when I use register server so I know they are running on port 1433 but I need to scan my domain and bring this information back to my CIO so he can set policy and gain control over this proliferation...Ideally I will be running a job to scan our network of new SQL servers instances that come on line from desktops or new/old server installs.   |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-03 : 14:10:42
|
| You can run "osql /L" on the command line to get a list of available SQL Servers on the network. It usually gets all of them (does on my domain anyway) |
 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-12-03 : 14:20:27
|
| 23 servers returned... My only problem now will be seeing the ones that are sitting behind Symantic and Windows Firewalls, that may have security access through application and NT accounts and may have downloaded sensitive data... Any suggestions? |
|
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2004-12-03 : 15:46:09
|
| A couple of servers that exist do not show up in the list... I checked the server network utility and the hide server is not checked on... From my local workstation I am able to connect to the box...Suggestions? AppreciatedThank you. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-05 : 21:39:24
|
| try sqlping--------------------keeping it simple... |
|
|
|
|
|
|
EMERGENCY SECURITY AUDIT