How To Find Out What SQL Server An Application Is Using

IT Support Forum Forums Databases Microsoft SQL Server 2014 Troubleshooting How To Find Out What SQL Server An Application Is Using

Tagged: 

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 1 year, 7 months ago.

  • Author
    Posts
  • #1112

    Webmaster
    Keymaster

    Sometimes you have an application and you don’t know what SQL Server it’s using and can’t log into the app to find out or don’t know where the configuration setting is for SQL to find out what sql server the application is using. Here’s how to find out what sql server an application is using:

    Log onto the application server and run netstat -a in the command prompt. This will list a bunch of servers (and PCs) that have connections to the server. The likelihood is, that one of those computers listed is the SQL server the application server is using. It will probably even say that the type of port is SQL (ms-sql-s).

You must be logged in to reply to this topic.