Purpose

Many times a database administrator will want to know what SQL Server instances are running on a remote server.
Below is a simple, command-line method for determining that information, either against a single server or multiple servers.
Go HERE to download the full script to have a complete working copy of both the wrapper (calling script) and the main (called) script

Assumptions

1) You have a c:\scripts folder
2) You have adequate permissions/privileges to run necessary commands against a remote server
3) You know how to enter / invoke the Windows command shell

Steps

1) How to Execute Against a single server

From any computer where the user has appropriate privileges, in the Windows command shell, after saving the “instances.bat” script below to your “c:\scripts” folder, type:

C:\scripts\Instances remote-server

Where “remote-server” is the name of the server whose SQL instances you want to list.

 

2) How to Execute Against Multiple Servers

To use in a batch file, against multiple SQL servers, create 2 batch scripts:
  a) One batch script to be "called" by the other.
  b) One batch script to "call" the first ("called") script.

For example, instances.bat (below) will be the "called" script:

Create a Script to be Invoked (Called) by Another Script

[INSTANCES.BAT will be "called" by call-instances.bat]

Create a "Calling" Script to Invoke (call) the Previous (Called) Script

[CALL-INSTANCES.BAT will be the "calling" script.]
[This script will contain the list of all remote servers to be reported against, 3 in this example.]

NOTE: In the above script, remote-sqlserver1, 2 & 3 are the names of the remote SQL servers

Execute the "Calling" Script"

 
From Windows command shell, type:

 

Review the Log Results

 

 

Results from a Sample Run

 

---

See Also

The full script, containing both the wrapper (calling script) and your review)