Linked servers windows

Is there a way within windows server e.g. a command.. to get some clues on what app server is connecting to any databases on the local server? We have a legacy app with no documentation even as far as what the database platform is where the database files live or what apps connect to it.
LVL 3
pma111Asked:
Who is Participating?
 
pcelbaCommented:
If you don't know what database platform is installed then look at running services and then at a list of installed programs. Names are always descriptive enough. Once you'll recognize the platform download the appropriate tool for database management.

SSMS mentioned in the previous post is OK for MS SQL Server but other databases will need their respective tools. And you'll need some credentials to connect the engine... If MS SQL is configured for Windows authentication then local admin can connect directly using Trusted login. Other database engines are not so friendly obviously.

You may also look for multiplatform database management like e.g. DataGrip: https://www.jetbrains.com/datagrip/features/
0
 
dfkeCommented:
Hi,

if you're using MS SQL then login with the management studio  so you can check the security logins of the installed instances that might give you a clue.

Cheers
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Is there a way within windows server e.g. a command.. to get some clues on what app server is connecting to any databases on the local server?
Why not use SQL Server for that? You can do is to Audit the SQL Server databases and hope that when an application is connecting to a database, it sends the application name.
You can also open a SSMS query window and run the following command to have a snapshot of the current connections:
EXEC sp_who2

Open in new window

This will return all current connections to the SQL Server instance and you can check if there's any data in the ProgramName column. But this information is provided by the application that's connecting to the database and some programs just leave it empty.
0
 
pcelbaCommented:
The app exists already. So the SQL Server usage is not in pma111's hands.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.