• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

Discover all SQL Admins on SQL servers

We are putting together a security audit and would like to be able to (1) detect all SQL Servers or instancess running and (2) be able to determine the SQL admins associated. We can use NMAP and determine the SQL instances and then have that list in a text file. But does anyone have any idea on how we could then pull SQL admins from those servers remotely without having to go to each server and run something manually. Looking to automate this as much as possible and searching for suggestions.
0
cmhwsu
Asked:
cmhwsu
1 Solution
 
SStoryCommented:
Well, you could write an app, like vb.net that connects via connection string to one server after the other and runs a query on:

use master;
select * from dbo.sysusers

You'd have to know what you were looking for. It will also depend upon whether you are using standard security, or the Windows security or mixed.

In standard there is only sa for root
In Windows all users with admin access on that machine are SQL Server admins too.  In mixed this is also a concern. If you just mean dbo or a certain role, you can get that info from this table too.
0
 
cmhwsuAuthor Commented:
It appears this is basically what we will have to do. Thank you.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now