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
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.