Please note that Sahi's development and support teams do not actively monitor this. This is more a community forum. If you are a Sahi Pro user looking for commercial support, please email support @ sahipro.com with your query.

Error connecting DB - SQL Server 2008

deepakkadamdeepakkadam Members
edited 12:58AM in Sahi - Open Source
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

Comments

Sign In or Register to comment.