When I deploy the reports I get the following warning
Cannot deploy data source DataSource1 to the server because it already exists and OverwriteDataSources is not specified
Is there any way of specifying Overwrite data source.
Any suggestion is highly appreciated.
Its in the properties of the report project...|||Thanks I got that.If i go to Central Administration > Configure Reporting Services Integration,
I can see the settings, thats mean that the Report Server is available ( i think so )
And also i can create dataources on Central Administration Web site (//servername:12500)
But from my production server web site ( //servername/ ), i cannot create those items.
I received the message
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
Can somebody help me to fix that strange behavior.
Thanks.I check the security on the at the below level :
- IIS Site and Application Pool (For Sharepoint:80 and Sharepoint Admin Console:12500)
- Permissions on the folder (Is the same).
- The site Owner is the same on both
The communication from the Sharepoint Admin Console allow any access to RS2005.
For some reason that site have permission to see Reporting Services.
But from Sharepoint Services Portal i can not.
Thanks again.
Hello, I Created a report with reportbuilder, after clicking on Run Report I got this message, Its very strange it seems that its trying to generate or create a datasource.
Para obtener más información acerca de este error, vaya al servidor de informes en el equipo del servidor local o habilite los errores remotos
-
No se puede crear una conexión al origen de datos 'dataSource1'.
-
Error al procesar el informe.
Hello,
This error means that the connection could not be established with the information provided in the data source element, named 'dataSource1', which is in the RDL that report builder creates.
There should be more information regarding why this error occurred in the log files. See the following link on how to locate the log files.
http://msdn2.microsoft.com/en-us/library/ms157403.aspx
Ian
I have been working on a report for a while now and just when I go to deploy it, the bloody thing stops working.
I have been testing it mainly under my account (Admin + Domain Admin) and peridocally under another admins account. I have also been testing it under a dummy normal account (domain user only) and up until now it has worked fine.
Originally it did not work although I found that if I Rebuilt & Redeployed the project to the server and then started Reporting services and selected the datasource1 and supplied my credentials and checked Use as Windows Credentials and also the Impersonate check, it all worked perfectly.
However now this does not appear to be the case
The exact error I get is
'An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DashboardSQL-2K5'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors'
The connection string under the properties of datasource1 are
INTEGRATED SECURITY=SSPI;INITIAL CATALOG=DashboardSQL-2K5;DATA SOURCE=XXXXXXXX;
XXXXXXXXX is obviously the name of my server blanked out
Please help as I wish to deploy this report and it is just sods law that it stops working today.
Regards
Further poking around etc showed me that there were a couple of setting adrift in the various places.
I am now at the point where I have got it to work, the only problem I now have is that unless I grant DomainName\Domain Users as sysadmin in the permissions for the database, I get an error similar to below when I try to go to
http://ServerName/Reports
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'srcqry_weeklydatadate'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
Now that query it is trying to run is a select query in the report that populates the first parameter box on the report selection criteria. What do I need to change in the report to prevent this from happening. I can't very well allow all and sundrey in as sysadmin for obvious reasons.
Regards
|||Open data source props and make sure that credentials are set to "Windows integrated security" or "Use as Windows credentials when connecting to the data source"