Solved

identify the application server which connects to the sql database.

Posted on 2012-03-20
3
183 Views
Last Modified: 2012-04-01
Hello,

We have a legacy application server which connects to a sql database.  We plan to decommission this database but have trouble to identify the server which runs the application.  

Is there a way I can search from the database to identify which system connects to the database?

Thanks
0
Comment
Question by:nav2567
3 Comments
 
LVL 15

Assisted Solution

by:Anuj
Anuj earned 250 total points
ID: 37742829
Use SQL Server Profiler, or sp_who2 and check the column hostname for the details.
0
 
LVL 39

Accepted Solution

by:
lcohan earned 250 total points
ID: 37744723
Or you could simply use SQL 2005 SSMS "Activity Monitor" under Management to do that:

http://msdn.microsoft.com/en-us/library/ms175518(v=sql.90).aspx
0
 

Author Closing Comment

by:nav2567
ID: 37793106
thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

920 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now