search cancel

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

book

Article ID: 189114

calendar_today

Updated On:

Products

CA Cloud Test Mobile CA Application Test

Issue/Introduction

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

Environment

Release : 10.4

Component : CA Service Virtualization

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.