Why do I get an “A connection could not be obtained" error for the SAP Connector?
Gerd Schiering (122●1●13●16)
| asked Jan 20 '15, 4:29 a.m.
JAZZ DEVELOPER edited Jan 20 '15, 5:11 a.m.
Setting up the IBM Rational SAP Connector with an MS SQL server database throws a connection error when accessing projects in the UI in the web browser.
"A connection could not be obtained for driver class "com.microsoft.sqlserver.jdbc.SQLServerDriver".... You may have specified an invalid URL." The same message details is also found in C:\IBM\SapConnector\server\tomcat\logs\localhost.2015-01-15.log The DB server can be accessed from RQM without errors and other databases on that same SQL server can be reached as well. |
One answer
|
The root cause was a missing semicolon at the end of the jdbc connection string property in C:\IBM\SapConnector\server\conf\sapconnector.properties A semicolon: ";" is needed to terminate each line in the sapconnector.properties file. |