How to identify the SQL Server and Instance Name using Command prompt

Introduction

This topic explains how to identify the current SQL Server name and current SQL Instance Name.

1. Click Start, Run.

2. Type in cmd and click OK.

3. Type in cd\ and press Enter.

4. Type in cd IRIS and press Enter (this assumes the IRIS folder is in C:\IRIS\).

5. Type in iCoreShowDBInfo and press enter.

The DataSource is the full SQL Server name.

• If you are using the default SQL instance then the SQL Server name will simply be the name of the server itself.