August 12, 2011 at 6:45 am
Hi.
Report server - I can able to see the report and deployed preview report is working fine. and data getting from remote server, this particular report mention data source - userid "sa" and password.
I tried remote PC - http://Ipaddress/Reportserver
I got error like as blow, please help me how to resolve this issues.
An error occurred during client rendering.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Backup'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
thanks
August 15, 2011 at 1:36 pm
Do you know if Kerberos is enabled? Typically I have seen this error when it is not and trying to use the SA account would usually confirm this...
Assuming you are not using Kerberos. First make sure your report is connected to a data source. Navigate and select the report, click on the Properties tab, then click down to Data Sources in the left nav. Tell us if you are using a Shared Data Source or an Embedded Data Source and which you are trying to use? If it is a shared data source, make sure that you have selected the proper data source then go back and find the data source and make sure it is set up properly (connection string, uid, pw, etc.). If it is an embedded connection, select the Store Credentials Securely in Report Server option and type in the userid, pw, etc. and apply. Sometimes you have to toggle the two checkboxes (use windows authentication and impersonate user)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply