search cancel

How to specify SQL SERVER with instance name during Installation of DevTest

book

Article ID: 189114

calendar_today

Updated On:

Products

CA Application Test Service Virtualization

Issue/Introduction

Need help and guidance in Installation of DevTest on Windows Server.  How do you specify SQL SERVER with instance for Database connection strings?

Environment

All supported DevTest releases.

Cause

N/A

Resolution

For SQL Server  connection strings with instance name,  use the following syntax:


jdbc:sqlserver://[serverName[\instanceName][:portNumber]];databaseName=<database_name>
 
or

jdbc:sqlserver://<hostname>;instanceName=<instance_name>;databaseName=<database_name>

 
Note **: If you are providing using Datasource updater for IAM, make sure that you escape the slashes properly so that the JDBC string written in standalone.xml is of the above format.