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 4
pma111Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.