Can't Connect to MS SQL Server in Configtool with a dynamic port and a DB instance name

Products

• Output Management Web Viewer

Issue/Introduction

Configuring the database for a dynamic port when the Web Viewer ConfigTool requires you to provide a specific PORT value.

Specifying a DB instance name when the ConfigTool does not prompt for this parameter.

 

Environment

Release:- Web Viewer 12.1
Component:

Resolution

When you enter the [JDBC URL] value in the config tool, you can type whatever you want there.  There will be a recommended value you can ignore. This is how you can enter what you want for this string.

1. Since the OMWV ConfigTool setup procedures always expect you to provide a PORT value, specify a dummy port value when running the configtool and then remove the port value from the URL along with the preceding ":"  .
2. Provide the DB instance name, for example, \SQL2012TEST2 

Here is an example of how the string will look:
jdbc:sqlserver://testsqld21\SQL2012TEST2;databaseName=omweb 

Enter your new string when you are prompted Enter a new value or press [Enter] to use the current value:.  This is a transcript of how to do this:

[JDBC URL] 

Recommended value: jdbc:sqlserver://SQLSERV123\SQLEXPRESS:1433;databaseName=omweb 

The current value: 

Enter a new value or press [Enter] to use the current value:

Database JDBC URL: jdbc:sqlserver://testsqld21\SQL2012TEST2;databaseName=omweb 

 

NOTE: :1433 has been removed.  The db instance name SQL2012TEST2 has been specified.

 

 

Additional Information

CA Output Management Web Viewer 12.1 Documentation

 

Click here if you need to open a CA Support Case.