Tweet
Using RBD & RDP I am trying to connect (while creating a new connection) to MS SQL Server 2005 and for that I am using “SQL Server 2005 – Microsoft SQL Server 2005 JDBC Driver Default” (sqljdbc4.jar).
In the connection screen when I am using a valid User Name and Password (already created in SQL Server) I can successfully connect to the SQL Server,
But when I am trying to use the “Use integrated authentication” option (In the targeted SQL Server my user id already been created with user authentication type) getting the error “The driver is not configured for integrated authentication” with the below details – com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
After looking in the web I found it need to use the sqljdbc_auth.dll for the integrated authentication before calling the connection object from java.
I have no idea how I can configure this in RBD/RDP, or is there any other way around to connect to the MS SQL Server using the integrated authentication option.
Any guidance/help will be highly appreciated.
Thanks & Regards
Dibs
In the connection screen when I am using a valid User Name and Password (already created in SQL Server) I can successfully connect to the SQL Server,
But when I am trying to use the “Use integrated authentication” option (In the targeted SQL Server my user id already been created with user authentication type) getting the error “The driver is not configured for integrated authentication” with the below details – com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
After looking in the web I found it need to use the sqljdbc_auth.dll for the integrated authentication before calling the connection object from java.
I have no idea how I can configure this in RBD/RDP, or is there any other way around to connect to the MS SQL Server using the integrated authentication option.
Any guidance/help will be highly appreciated.
Thanks & Regards
Dibs