Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, windows and java based applications. Get your 30 day free trial.
Discuss your Sahi Pro usage patterns, best practices, problems and solutions. Help others solve their problems and seek help from the community when needed. If you need specific support on your application, please email support @ sahipro.com
Discuss your Sahi Pro usage patterns, best practices, problems and solutions. Help others solve their problems and seek help from the community when needed. If you need specific support on your application, please email support @ sahipro.com
Error connecting DB - SQL Server 2008
deepakkadam
Members
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
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
Solution : sqljdbc_auth.dll file needs to be added into C:\WINDOWS folder and sahi\lib folder.