How Do I find out my SQL server and Instance Name
Article ID
ias-6212
Article Name
How Do I find out my SQL server and Instance Name
Created Date
30th April 2008
Product
Problem
Some times it may be required to know what your IRIS SQL Server and Instance names are?
Resolution
The following instructions will show you how to find this information.
Click Start
Click Run
Type CMD
Type C: and hit return.
NOTE: If the IRIS folder is on a different drive then use this letter ie D:
Type CD\IRIS then hit return.
Type icoreshowdbinfo and hit return.
Information similar to the following should be displayed.
C:\IRIS\>icoreshowdbinfo
Common connection: DataSource=p002759\IRISPRACTICE, Initial Catalog=iris, Login=irisdbo
Customer database: VisibleName=Practice, Server=p002759\IRISPRACTICE, Database=iris, Description=IRIS Practice Software Client Database, Login=Practicedbo
Datasource = Is the Server & Instance name
Initial Catalog = Is the Database name
Share This Page
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.
