Cannot create a new database connection to SQL server named Instance

  • KM02416497
  • 15-Jun-2016
  • 15-Jun-2016

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