search cancel

12.1 install using SQL problem

book

Article ID: 134508

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/Introduction

Environment is Windows 2016 using SQL 2016, installing 12.1 file med5-1070

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 OMWV 12.1, what do I tell the config 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: 1
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

Release : 12.1

Component : CA OUTPUT MANAGEMENT WEB VIEWER FOR ALL PLATFORMS

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.

It gets more complicated if the SQL Server is further (SSL/TLS) secured. We discussed this among our selves yesterday in our support case review meeting. It was mentioned how the DB Server default port is 1433 and how 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.

Additional Information

Actual resolution: At the end of the DB configuration. where it prompts you, [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: if it's correct, you need to copy the "Recommended value" and paste it at the "Database JDBC URL:" before you test the connection.