SSRS Deployment is so troublesome!!

Question

SSRS Deployment is so troublesome!!

pilypala

SSChasing Mays

Points: 653
More actions
September 13, 2009 at 10:59 am

#226121

1.
I am new to SSRS, and I am so frustrated with deployment, I got a book, but it keeps on telling me go to IE and type in:
http://localhost/ReportServer
I think my localhost is called: John-PC/mysqlinstance
My database instance is called: mysqlinstance
My questions are:
*** what will my ReportServer's name be?
*** what URL do I need to type in to get my reports on IE?
I only worry about SSRS, don't care abt .NET at all.
2. How can I copy all files (.sln , .rdl) to Report Manager?
Where is Report Manager locate in my PC by default??
3. In visual studio, report solution explorer, what should I type in for TargetServerURL under report's property tab?
many thanks
P

Viewing 11 posts - 1 through 10 (of 10 total)

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

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 1

Just out of interest, have you taken a brief run through either books online (BOL), or a tutorial (google for "Bill Pearson III" , he has several and is the first hit for databasejournal; alternatively, BOL has a few too)?

Anyway, assuming you do go through those at some point, you can easily find your reporting services URL by using the Reporting Services Configuration tool, it has the URL for the given instance that you connect to.

You don't 'copy' files per se, up to your Reporting Services 'Report Manager', you open your project in BIDS (ie visual studio) and Publish the report (or reports) to a specified server (ie the one you found in step 1). You can 'import' them into Report Manager by using the menu options within Report Manager if you want to try that option (slower).

The target URL is the one seen in step1, except you'll notice that in the config tool, it gives you the URL for report manager plus the URL for publishing too. You'll find them both in there.

HTH,

Steve.

becklery Hall of Fame Points: 3315 More actions · Answer 2

Hi, pilypala.

Maybe you can try RAQ Report[/url], for it provides a better integration solution.

RAQ Report provides integration as Jar package to programmers. Without independent report server, application infrastructure, and independent management mechanism of user permissions, RAQ Report can help programmers to implement integration conveniently. Its application architecture is shown below:

The advantages of no independent report server:

? The server of RAQ report is submitted as Jar package or application of application server. Therefore, it can get integrated with application program seamlessly to achieve the peak operating efficiency.

? Share the cluster capability and the management capability of connection pool of application server.

? Make unified deployment. Use the user role management mechanism of Web application directly to avoid the incompatible problem of two management mechanisms. Provide a unified login screen, and end users need not to log in twice.

RAQ Report: Web-based Excel-like Java reporting tool[/url]

pilypala SSChasing Mays Points: 653 More actions · Answer 3

I dont think my boss will be particularly happy to change from ssrs to something else...

Swetha Sankaran-465186 SSC Veteran Points: 297 More actions · Answer 4

My questions are:

*** what will my ReportServer's name be?

Start-> All Programs -> Microsoft Sql Server(2005/2008) -> Configuration Tools -> Reporting Services Configuration Manager.

You will see all the info about your report server there.

*** what URL do I need to type in to get my reports on IE? and Where is Report Manager locate in my PC by default??

In Reporting services configuration manager: Click Report Manager URL

You will see the URL for report manager where your reports will be deployed to(This is assuming your Report Server is configured in Native mode)

2. How can I copy all files (.sln , .rdl) to Report Manager?

SSRS reports are deployed through Visual studio. You have to configure the project's deployment properties.

3. In visual studio, report solution explorer, what should I type in for TargetServerURL under report's property tab?

In your visual studio Reporting services project

Try the following,

TargetDataSourceFolder: Data Sources

TargetReportFolder: Reports

TargetServerURL: The url you obtained from RS configuration manager's ReportManager URL section.

Once the deployement succeeds you'll see the reports listed in report manager.

Good luck!

pilypala SSChasing Mays Points: 653 More actions · Answer 5

pilypala

SSChasing Mays

Points: 653

September 14, 2009 at 12:28 pm

#1053379

thanks I will give it a shot!

pilypala SSChasing Mays Points: 653 More actions · Answer 6

Swetha Sankaran (9/14/2009)
*** what URL do I need to type in to get my reports on IE? and Where is Report Manager locate in my PC by default??
In Reporting services configuration manager: Click Report Manager URL
You will see the URL for report manager where your reports will be deployed to(This is assuming your Report Server is configured in Native mode)
Following is my URL obtained from my SSRS Configure Manager:
http://pilypala-pc:80/report_server
However when I click on the link, my IE opened up but saying Error 404...URL can not be found..
Do you know why??
I have this problem all the time, IE somehow doesn't work with my SSRS...