Link to home
Start Free TrialLog in
Avatar of ACECORP
ACECORPFlag for United States of America

asked on

Is there a quick way to determine which servers are connecting to and interacting with a sql 2005 database?

I have a sql server 2005 enterprise edition x64 cluster that contains numerous virtual instances. each virtual instance contains a sql instance, and the sql instance contains numerous databases.

there is one database that is "unknown" and i was wondering if there is a quick way to determine, by executing something up against the sql server or database itself, which servers are connecting to and accessing this database?

I am not interested in a solution where i need to look at switches, routers, or anything of that nature. i am only interested in uisng a method on the sql server itself, looking at the databse via a query server side mechanism to find out which servers may be connecting to the specific database.

i want to avoid having to run a network monitor and tracing out the tcp/ip packets. i am hoping for a quick and easy solution where i can just run something on the sql server that takes less than 60 seconds.

ASKER CERTIFIED SOLUTION
Avatar of Paul MacDonald
Paul MacDonald
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ACECORP

ASKER

That worked. Problem solved. Thank you.