Post reply

SSRS Deployment is so troublesome!!

  • 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

  • September 13, 2009 at 12:33 pm

    #1052845

    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.

  • September 14, 2009 at 7:57 am

    #1053215

    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]

  • September 14, 2009 at 8:48 am

    #1053261

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

  • September 14, 2009 at 12:23 pm

    #1053375

    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!

  • September 14, 2009 at 12:28 pm

    #1053379

    thanks I will give it a shot!

  • September 14, 2009 at 12:36 pm

    #1053386

    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...

  • September 14, 2009 at 12:40 pm

    #1053388

    Can you try http://pilypala-pc:80/reports

  • September 14, 2009 at 12:47 pm

    #1053392

    Still doesn't work

    what do I need to tpye in for the field VIRTUAL DIRECTORY?

    I just tried to type in "Reports" , it didn't work..

  • September 14, 2009 at 12:55 pm

    #1053399

    http://technet.microsoft.com/en-us/sqlserver/dd370686.aspx

    walks you through the deployment .

  • September 14, 2009 at 12:59 pm

    #1053403

    For some unknown reasons, when I change port number 80 to 8080, everything works fine!!

    virtual directory:

    report_server

    report manager url:

    http://yan-pc:8080/report_server

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

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