Remotely Administration

[scottsanpedro]

Hi,
I wonder of someone would know the answer to the following.
I have created a system for a company that uses SQL 2005. They want to use reporting services.
In the past I have always VPN or RDP to the computer and with Visual studio I have set up the reports and deployed.
I wondered if its possible to create and deploy the reports remotely. I will have a copy of the data structure locally on my PC.
Thanks in advance
Scott

 

[mrdenny]

Yes you can deploy the reports remotely as long as you have access to the SSRS website. When you have the reports in the BIDS project, edit the project and change the server setting to point to the SSRS site. Then right click on the project and select deploy.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[scottsanpedro]

Thanks for the answer.
So presumably I need to configure RS to have the ability to be seen by the outside world? Using SSL etc
Then effectively deploy to the external IP address
Thanks again
Scott

 

[mrdenny]

Yes, that's correct.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog