Webservice MS SQL authentication [message #965803] |
Wed, 31 October 2012 14:13 |
mr. burns Messages: 402 Registered: July 2009 |
Senior Member |
|
|
Hi,
I use latest BIRT inside the Eclipse Juno on a Windows 7 professional.
I use Microsoft Dynamics Nav 2009 RTC, behind there is an MS SQL Server 2008.
I created a BIRT report using a webservice datasource.
I setup the URL of the webservice.
If I run the report within the designer I get following error:
The following items have errors:
Table (id = 33):
+ Cannot execute the statement.
org.eclipse.datatools.connectivity.oda.OdaException: Server returned HTTP response code: 400 for URL: http://mysrvsql:7051/nav2009/WS/myCompany/Page/Customer
(Element ID:33)
I believe it is an authentication problem.
The webservice runs well inside an IIS website using PHP, there I had to auhtenticate with username and password.
My question now in BIRT how can I authenticate a webservice datasource against the MS SQL server? How I can provice username and password?
Thanks a lot for any help!
[Updated on: Wed, 31 October 2012 14:17] Report message to a moderator
|
|
|
|
Powered by
FUDForum. Page generated in 0.03363 seconds