Cannot connect to SQL Database with OM Web Viewer 12.1

Products

• Output Management Web Viewer

Issue/Introduction

Getting a connect failure with SQL.  Port is a required field, guessing 1433 but not working.  Unsure why a port is needed locally. 

If we are using SQL LOCALLY on the same server as OM Web Viewer 12.1, what do I tell the ConfigTool program?  The below information is what I have tried and it cannot connect. 

Database Connection Settings
--------------------------------------------------------------
[use an external database? (Enter 1 for Yes, 0 for No)]
The current value: 1
6:  No Change (SQLServer)
--------------------------------------------------------------
[Database type]
The current value: 6
Enter a new value:
--------------------------------------------------------------
[Host name]
The current value: 255.255.255.255  (tried this instead of hostname of the server to see if it would work)
Enter a new value:
--------------------------------------------------------------
[Port number]
The current value: 1433  (The server name and a default port of 1433 doesn’t work.  Port is required, but I don’t see why / how it would use it.)
Enter a new value:
--------------------------------------------------------------
[Database name]
The current value: dvweb (wasn’t created, hope it would auto-create like previous versions, then I created a blank DB hoping it would connect)
Enter a new value:
--------------------------------------------------------------
[User name]
The current value: docview1
Enter a new value:
--------------------------------------------------------------
[Password]
New password: (If you do not want to change the existing password, press [Enter].)*
Using the current password.
--------------------------------------------------------------
[Does this account have CREATE TABLE privileges? (Enter 1 for Yes, 0 for No)]
The current value: 0
Enter a new value:
--------------------------------------------------------------
[JDBC URL]
Recommended value: jdbc:sqlserver://255.255.255.255:1433;databaseName=dvweb
The current value:
Enter a new value or press [Enter] to use the current value:
Database JDBC URL:

Environment

• Microsoft Windows Server
• SQL Server
• Output Management Web Viewer 12.1 for Windows

Resolution

All the information prompted for is needed to test the connection - the Host Name or IP Address, the Port, the DB Name and the authorized User Name and Password. The part a lot of customers miss comes at the end of the DB configuration. where it prompts: 

[JDBC URL]

Recommended value: jdbc:sqlserver://555.555.555.555:1433;databaseName=dvweb

The current value:

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

Database JDBC URL:

if it's correct, you need to copy the "Recommended value" and paste it at the "Database JDBC URL:" before you test the connection.

 

Additional Information

NOTE: This article mentions SQL Server specifically but the resolution is the same for all external databases.

The DB Server default port is 1433 and the default, secured port is 5182. BUT... you can define 1433 to be secured and 5182 to not be secure. That's why it's important to double-check this with the SQL DBA.