Error connecting DB - SQL Server 2008

deepakkadam

I am not able to connect to SQL Server 2008 which uses my windows authentication. The port number to connect to the SQL Server 2008 is 1473. It's not the default 1433. I am getting different errors everytime.

Error 1:
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
along with the following trace message:
com.microsoft.sqlserver.jdbc.AuthenticationJNI <clinit>
WARNING: Failed to load the sqljdbc_auth.dll

Upon this I added the sqljdbc_3.0\enu\auth\sqljdbc_auth.dll to \sahi\lib. But getting the same error:com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

What else should I do here to connect to SQL Server and the authentication issue working?


My connection string and query:
var $db = _getDB("com.microsoft.sqlserver.jdbc.SQLServerDriver","jdbc:sqlserver://Server_Name:1473;databaseName=DB_name;integratedSecurity=true");
$rs = $db.select("select * from USER_NAME");

Sahi Version - V3.5 OS
OS - XP

deepakkadam

I got the solution to the above problem that I mentioned and now everything works fine.
Solution : sqljdbc_auth.dll file needs to be added into C:\WINDOWS folder and sahi\lib folder.

nitingautam

thanks for sharing, i believe you don't have to do something else for this to work ? like classpath?