October 20, 2011 at 12:06 pm
Hi
We have a nice new SQL Server 2008 R2 Enterprise server and an older SQL Serer 2005 standard server.
We would like to use datasources from the 2005 databases to create new reports on the 2008 server and also to deploy 2005 reports to the new server.
After deploying a 2005 report to our 2008 Reports Server we get this error
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'BudgetReport'. (rsErrorOpeningConnection)
Forinformation about this error navigate to the report server on the local server machine, or enable remote errors more
I suspect it's something to do with the service account being used to run SSRS 2008 and it not having sight of the old server.
If that's the case what's the type of account I need in the 2008 Report Server configuration and what permissions will it need?
Thanks
October 21, 2011 at 2:31 am
Seems like some kind of security issue, yes. Is BudgetReport using windows integrated security? Username and password? Are the required ports opened between the report server and the database server?
October 21, 2011 at 4:10 am
Yes, Windows Integrated Security in the datasource.
October 21, 2011 at 6:14 am
How about ports? Can you connect to the database server from the report server using other tools, such as SQL Server Management Studio, sqlcmd or other tool? I also asked whether the required ports are opened. SQL Server normally use UDP 1434 for SQL Server Browser, TCP 1433 for default instance and dynamic port (which you can alter to use static instead) for named instances: http://www.mssql.no/Mythbuster/?id=26
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply