Synopsis: In the DBMC connection, clicking Test Connection to a Remote Server says Connection Succeeded but clicking OK will give an SQL connection error.

Cause: You are trying to connect on the SQL Instance Name located remotely and Database Management Console (DBMC) is required to be on the SQL Server machine.

Solution: Install the Database Management Console (DBMC) in the SQL Server machine.

 

Applicable Products:

All Interprise Suite Versions

Was this answer helpful? 0 Users Found This Useful (0 Votes)