Report Designer Pro to SQL Server 2008 connection problem

Craigbob

Hi all,

We just downloaded the trial version of Report Designer Pro and are trying to connect to one of our databases in SQL server 2008.

Here are the steps I've taken:

I've created a project in IO designer and then a data object.
I then started to create a data source within that data object.
I right clicked in data source and chose create new data source
Chose JDBCDatabase Connection for Query Builder
Chose SQL server then Actuate SQL Server 2008 Driver and filled in the prompts.

It created the connection URL

jdbc:actuate:sqlserver://WDSCPMOP01:1433;DatabaseName=labor;AuthenticationMethod=auto

When I went to Ping the database the Ping Failed with the following Error:

java.sql.SQLException: [ActuateDD][SQLServer JDBC Driver]A username was not specified and the driver could not establish a connection using Kerberos (type 4) integrated security: No valid credentials provided (Mechanism level: Fail to create credential. (63) - No service creds)

So I tried entering my login info and again failed Ping with the following error:

java.sql.SQLInvalidAuthorizationSpecException: [ActuateDD][SQLServer JDBC Driver][SQLServer]Login failed for user 'sc\bobchin_c'

I've tried using the IP address of the SQL server as well as other servers that I normally connect to all with the same results.

Any help in solving this is appreciated.

regards

Craig

Clement Wong

There appears to be an issue with this particular feature when running on a 64-bit Windows system. I will file a ticket with the Engineering team.

In the meantime, if you want to get it work:

1. Close BIRT Designer Professional
2. Locate your install and find the file "DDJDBCAuth04.dll".


C:\Program Files (x86)\Actuate11SP4\BRDPro\eclipse\plugins\com.actuate.data.oda.jdbc.drivers_11.0.4.v20120420\lib

3. Copy the file "DDJDBCAuth04.dll" to the following two directories:

A. C:\Program Files (x86)\Actuate11SP4\BRDPro\eclipse
B. C:\Windows\SysWOW64


4. Launch BRD Pro

5. In your Report/Data Design, create a new Data Source - JDBC Database Connection for Query Builder
6. Choose SQL Server in the Connection Profile
7. Choose the Actuate SQL Server 2008 Driver
8. Enter your database, host and port info
9. Click on "Use integrated authentication"
10. Select the "Optional" tab
11. Add the additional property "AuthenticationMethod=type2"

Now you should be able to Test Connection and create a new Data Set.