Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Report Designer Pro to SQL Server 2008 connection problem
Migrateduser
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
Find more posts tagged with
Comments
There are no comments yet