pstre
asked on
SSRS report configuration
We have SSRS reports and the SQL server is now on a different server. Where do I need to go within SSRS to change the server name? Are there other places other than the data connection tab that I need to update?
If the SSRS reports are using a shared data source then you'll have to create/locate that data source on the new server, make sure it's pointed to the correct server.database, test, and save.
If the SSRS reports are using local data source(s) then you'll have to open every SSRS report and open ,make sure it's pointed to the correct server.database, and test, and save.
If the SSRS reports are using local data source(s) then you'll have to open every SSRS report and open ,make sure it's pointed to the correct server.database, and test, and save.
We have SSRS reports and the SQL server is now on a different serverWhat do you mean? Did you migrated SSRS database to another SQL Server instance? If so, you'll need to reconfigure SSRS to point to the new database location and for that you'll only need to open Reporting Services Configuration Manager and then in Change Database provide the new SQL Server instance information. If you also change the Credentials you'll need to provide them in the same screen.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
None of the answers was what I needed. I had to reach out to our GP partner for resolution. It involved changing every report, updating IIS, etc.
If you are just transferring ssrs reports from one server to another it is only connection of DataSource which you need to update.
However you can get more information for the MSDN blog