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

Products

• Output Management Web Viewer

Issue/Introduction

Configuring the database for a dynamic port when the OM 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

• Output Management Web Viewer 12.1
• Microsoft SQL Server
  
  

Resolution

When you enter the [JDBC URL] value in the ConfigTool, 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 OM Web Viewer 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, \SQL2019TEST2 

Here is an example of how the string will look:
jdbc:sqlserver://testsqld21\SQL2019TEST2;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\SQL2019TEST2;databaseName=omweb 

 

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

 

 

Additional Information