Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stephensze
Starting Member
2 Posts |
 Posted - 2009-01-11 : 02:46:20
|
| Server 1: Reporting Services broken but Database Engine okServer 2: Both Reporting Services and Database Engine ok, but report already exist so option of backup and restore is not viable.how do you now run Report Services in Server 2 for Server 1, without using backup and restore?tnx |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-11 : 03:01:44
|
| what do mean by reporting services in server 2 for server1? do you mean hosting reports of server1 in server2? then you need just to give targeturl as http://server2/reports2005 in report properties of server1 reports |
 |
|
|
stephensze
Starting Member
2 Posts |
Posted - 2009-01-12 : 01:06:10
|
| The reporting services service on one of our machines got broken for some reason. Database engine service is still ok.How do I copy the reports to another machine running reporting services without doing a backup and restore.The other machine already has reports on it. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-12 : 02:26:17
|
quote:
Originally posted by stephensze
The reporting services service on one of our machines got broken for some reason. Database engine service is still ok.How do I copy the reports to another machine running reporting services without doing a backup and restore.The other machine already has reports on it.
ok. then you could simply upload your reports to second server from report manager. But make sure the reports can access tables of first server for getting data (may be configure as linked server or use distributed query options like opnerowset) |
|
|
|
|
|
|
Reporting Services issue nid help