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.
