Deploying SSRS problems

Question

Post reply

Deploying SSRS problems

the_spoofer

SSC Veteran

Points: 243
More actions
September 1, 2009 at 4:02 am

#210100

Hello,

I'm very new to SSRS and have some general question of my experiences when deploying SSRS Reports.

First of all I'm developing reports with SSRS 2008 (backend DB SQL Server 2005) and got IIS 7 locally. Later on I want to deploy my report to a remote production server (windows server 2003/IIS 6.0

I ran the SSRS Configuration manager and configured the virtual directory. It says it created the virtual directory. However when I open IIS manager I don't see any virtual directories in my default site??

When I go look in the MS SQL dir in Program Files, I do see a directory called ReportServer and ReportManager with aspx files, web.config etc...

What is wrong here?

Next to that, how can I deploy my report to a remote IIS Server. What steps to I need to take?

Thanks in advance

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 1

Answer for your second question is

TargerServerURL ? http://remoteserver/ReportServer

OR

Copy the solution to remote server and deploy

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

the_spoofer SSC Veteran Points: 243 More actions · Answer 2

Arunkumar S P (9/1/2009)

Answer for your second question is

TargerServerURL ? http://remoteserver/ReportServer

OR

Copy the solution to remote server and deploy

If i do the first option I keep getting an annoying dialog box.

How can I copy the solution? In the solution I just hava a bunch of .rdl files. How do I create aspx pages of this?

Do I just copy the virtual directories from my local machine to production? Sounds weird

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

If i do the first option I keep getting an annoying dialog box

That dialog box means there is a lot of permission that you need to define. Check the middle of the thread below for most known issues. You are in Vista you may have to disable protected mode in IE.

http://qa.sqlservercentral.com/Forums/Topic719964-150-1.aspx

How can I copy the solution? In the solution I just hava a bunch of .rdl files.

There is only one RDL file per report so copy each RDL file and all the associated solution files for the remote deployment. You also need to make sure your IIS7 is configured to run IIS 6 mode. In the remote ReportManager you need at least content manager role or admin so you can deploy and run the reports.

How do I create aspx pages of this?

If you need to run these in Asp.net application you use the VS2008 version of ReportViewer control check the link below for how to use the web edition of it.

http://www.gotreportviewer.com/

Do I just copy the virtual directories from my local machine to production? Sounds weird

The short answer is no.

Kind regards,
Gift Peddie