Forum Discussion

Grafische_bedri's avatar
Grafische_bedri
New Contributor
15 years ago

MSSQL 2008r2 database connection in Pro w. windows security

Hi! (I've posted this question in the other section of the board as well, which was before I found out we have a Pro support login) I'd like to ask a question regarding connecting to a MSSQL 20...
Grafische_bedri's avatar
Grafische_bedri
New Contributor
15 years ago
Hi,

THanks for your reply.

The error I get is:
Can't get the Connection for specified properties; com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'USERNAME'.


However, I did manage to work around the security issue by using an ODBC link instead by setting up a database connection using:
Driver: MSSQL(ODBC)//com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String template: jdbc:odbc:<ODBC-link-name>

Regards,
Jeroen.