Is Windows Authentication / Integrated Authentication connection supported to connect to MS SQL server 2005 on DD? We are trying to connect to a MS SQL server using the SQLJDBC.jar provided by Microsoft. The SQLJDBC.jar version is 1.2.
While adding a new DataSource in DD, we specify the following options:
In the Project Properties->Dialog Designer->Data Sources, we added a new JDBC Datasource as WinA. The Driver class name is com.microsoft.sqlserver.jdbc.SQLServerDriver and the connection URL that is specified is
jdbc:sqlserver://172.22.1.144:1433;databaseName=GroupDB;integratedSecurity=true;
In the Windows->Preferences->Dialog Designer->Database we added the driver corresponding to the SQL server (sqljdbc.jar). The sqljdbc.jar is copied in the TOMCAT_HOME/common/lib/ folder.
When we try to create the DBOP for the first time, we are able to see the Data Source name listed properly. Then the DD toolkit connects to the remote server and we are able to see the DB Schema/tables of the remote server. I am able to browse through and select the table to form my select query. In the DBOP window, i try to goto the SQL Query tab and "Execute" the query that is given. The following error occurs:
"The driver is not configured for integrated authentication." immediately after this, we get another exception saying "Error executing the SQL statement".
After this we are not able to browse through the DB Schema. Even while creating a new DBOP, we are facing the same issue. However, if the restart DD, the very first time, it is able to connect.
On checking the internet, there was a suggestion to copy the sqljdbc_auth.dll available inside the JDBC setup to the C:\Windows\system32\ folder. even this fails.
Request your assistance.
Thanks
B.Sriram
|