Webviewer 12 config tool failing connection test to remote SQL server

Products

• Output Management Web Viewer

Issue/Introduction

When attempting to perform an install of webviewer 12.1 and connect to a new SQL database, the configtool reports Connection unsuccessful, even though the server has been confirmed reachable, and the username and password are verified to be correct.

Upon looking in the configtool's ConfigTool.log located in [webviewer_home]\util\logs The following error appears:

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'xxxxxxx'. ClientConnectionId:#####..... at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at connectURL.main(connectURL.java:18)

Environment

Webviewer 12.1
Microsoft SQL Server

Cause

 the SQL Server / User on the SQL server, is not set up to accept logins from JDBC drivers/SQL logins. 

Resolution

The DBA responsible for the SQL Server must set the server and user to allow for SQL Server Authentication or Mixed Mode.