12.1 install using SQL problem
Article ID: 134508
Updated On:
Products
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.
Feedback
