Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2011-10-28
Medium Priority
Last Modified: 2012-06-27
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.

Question by:ACECORP
LVL 35

Accepted Solution

Paul MacDonald earned 2000 total points
ID: 37046304
You can use the Profiler in the SQL Manager to do this.  You'll need to go to the Events Selection tab, check the "Show all columns" checkbox and check the "Hostname" checkboxes.

That said, can you not determine the purpose of the database by looking at its contents?

Author Closing Comment

ID: 37046551
That worked. Problem solved. Thank you.

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question