Thursday, December 6, 2012

ER Studio connecton issue

 

Errors:

 

Connection failed:
SQL State: '01000'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
Instance())
Connection failed:
SQL State: '08001'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection

 

Rosolution:

 

Use servername\instancename,portnumber

Portnumber is 1433