Reputation: 18171
Get all SQL Server services in my machine
I got strange feeling that my local computer runs several versions of SQL Server. How to know all running SQL Servers on my PC?
Upvotes: 0
Views: 335
Answers (1)
Reputation: 28890
How to know all running SQL servers on my PC?
Best way would be to go through configuration manager ..As per your version you can open configuration manager and see all the versions of sqlserver installed.
Below is a snippet from my local machine
One more way would be to go through discovery manager,if you have installation media on your system.. you can double click the setup file and click on tools as shown below
and finally you can see all versions of sqlserver in a report like below .Distinct instance Id is the number of instances here.Opening sqlserver 2016 discovery report won't show 2017 instances,so always open with highest version
Upvotes: 2
Related Questions
- Get list of databases from SQL Server
- How to get a list of all the MS SQL Server instances on the local machine?
- PowerShell - List all SQL instances on my system?
- how do I get a list of SQL Servers System procs
- Get list of all System Databases in SQL Server
- How to get the list of installed windows services using SQL Query
- List all the available databases running on particular instance of SQL Server
- How to know which machine is running windows service
- SQL request to list all databases in an instance of Sql-Server?
- Get list of all sql servers installed in the system