Deploying reports and setting up reporting services on a clustered server

Hi

I have two questions:

1)

I need to deploy reports to a server in Spain, which I do not have direct access to. Is there any way that I can simply deploy the reports to a server here, that I have access to, and then copy the reports to the server in Spain? Or is there any other way? I cannot expect the customers in Spain to be able to use Microsoft Visual Studio 2005 themselves to deploy reports (they do not even have access to the tool).

2)

How do I set up reporting services on a clustered server? I have configured reporting services on both clusters, but somehow I cannot initialize both of them. Only on will be initialized at a time. Does anyone have experience with this?

Thanx :-)

Hello Heidi,

As for #1...

You can create the .RDL files from your machine, then place them in a location that the server in Spain has access to. Now, you can upload them into the reporting server via Report Manager. Select 'Upload File' from the menu bar in Report Manager, then navigate to the .RDL file and hit Ok.

For #2...

Are you trying to use an active/passive or active/active cluster? Here are a few links from Microsoft that might be able to help you.

http://msdn2.microsoft.com/en-us/library/ms157293.aspx
http://msdn2.microsoft.com/en-us/library/ms156453.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx

Hope this helps.

Jarret