Cannot create a new database connection to SQL server named Instance

  • Document ID:KM02416497
  • Creation Date:15-Jun-2016
  • Modified Date:15-Jun-2016
    • Micro Focus Products:
      quality center 12.21

Summary

ALM cannot connect to a project database stored in a SQL Server named Instance

Error

Can't create a new database connection for url 'jdbc:mercury:sqlserver://SQLServerName\Instance:1433' on setting catalog to 'default_lab_project_db1'
java.sql.SQLException

Cause

ALM does not support  database server alias with "\", ALM supports database parameters for establishing connections to MS SQL server named Instances, which involves "\".

Fix

Remove "\" or "/" from ALM database server alias name:

Already created database servers in ALM



DBServerAlias


When creating a database server in ALM


CreatingDbServerAlias