|Webservice MS SQL authentication [message #965803]
||Wed, 31 October 2012 14:13
| mr. burns
Registered: July 2009
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
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.02830 seconds