BIRT Rpt Designer- not able to create datasource for SQL server 2005

sdeshmukh

<span class='bbc_underline'>Tool: </span>Actuate 10 BIRT Report Designer <strong class='bbc'>trial version.</strong><br />
<br />
<span class='bbc_underline'>Problem</span><br />
<br />
While creating a datasource for my report, when I connect to Sql server 2005, I am getting the following error.<br />
"Drive could not establish a connection using Kerberos integrated security.....<br />
/lib/JDBCDriverLogin.conf" (No Such file or directory) "<br />
I think there is some problem with the Driver URL string that I am passing with.<br />
<br />
<span class='bbc_underline'>Attachment</span><br />
<br />
Please look at the attached screen shot for more details.<br />
<br />
<span class='bbc_underline'>Additional Info:</span> <br />
<br />
I use windows login & password to connect to SQL Server. (ODBC connection works fine with this)

Virgil Dodson

Hi Swapnil,<br />
<br />
I'll start by saying I am not an expert at using Kerberos authentication but I did a bit of checking around and may have some things to try.<br />
<br />
First of all, since Actuate BIRT includes DataDirect drivers for connecting to SQL Server and those drivers support Kerberos authentication, we should be able to make this work.<br />
<br />
I found some good information at:<br />
<a class='bbc_url' href='http://media.datadirect.com/download/docs/ddxquery/allddxq/reference/wwhelp/wwhimpl/common/html/wwhelp.htm?context=User_s_Guide_and_Reference&file=advancedfeatures9.html'>http://media.datadirect.com/download/docs/ddxquery/allddxq/reference/wwhelp/wwhimpl/common/html/wwhelp.htm?context=User_s_Guide_and_Reference&file=advancedfeatures9.html</a><br />
<br />
The things I think are worth trying are:<br />
<br />
Try to find the files krb5.conf and JDBCDriverLogin.conf. These files should be in the /lib subdirectory of your DataDirect XQuery installation directory.<br />
<br />
If you have configured Kerberos authentication your machine, these should be somewhere. Try copying these to c:program filesactuate 10brdeclipsepluginscom.actuate.data.oda.jdbc.drivers_2.3.2lib since it seems to be looking in that location.<br />
<br />
You should also try the steps at the link above under "Permissions for Kerberos Authentication" which talk about using the Kerberos permission under Java. You may have to add -Djava.security.manager to the eclipse.ini file located in the c:program filesactuate 10brdeclipse directory. There are other steps in that section to take a look at as well.<br />
<br />
I hope these things help.