SQL Server Performance

Newbie to RS - help wanted with URL and accessing Adventureworks

Discussion in 'SQL Server 2005 Reporting Services' started by jaybee, Aug 28, 2008.

  1. jaybee New Member

    Hi all, two problems, home page and Adventureworks.
    I have an installation of RS from a few months back, I can open Reporting Manager but have never been able to access AdventureWorks Sample Reports, though I see the DB in Studio . Both the RS and IIS services are running. I've tried:
    http://localhost/reports, and http://localhost/reports/Pages/Folder.aspx, these return a 'Server /A' error.
    However, this url gets me into the Production2005 DB
    http://localhost/reports$production2005/Pages/Folder.aspx . 'Production2005' is the name of my SS2K5 installation.
    I've tried replacing Production2005 above with Adventureworks, but no cigar. While in RM I fired up Report Builder, and saw a message saying, "No report builder models are available. To use report builder atleast one model must be published to the report server"
    I get the feeling that something quite basic is going wrong, or hasn't been configured right.
  2. martins New Member

    Hi,
    I gather from the given information that your SQL instance is named (Production2005). That is why you cannot use http://localhost/reports because it will then look for a default instance. Accessing it via the url that works is the right way to go.
    The reason for you not seeing any AdventureWorks reports is because they have not been deployed to your ReportServer. You will have to look for the Reporting Services project, open it and deploy the project to your ReportServer.
    Have a look at the CodePlex site (www.codeplex.com) for more information on any Microsoft samples.
    Hope this helps.
  3. jaybee New Member

    Thanks - sorry if the following are questions with glaringly obvious answers, but I'm an absolute beginner to RS - apart from installation I quite literally started this morning!
    [quote user="martins"]
    Hi,
    I gather from the given information that your SQL instance is named (Production2005). That is why you cannot use http://localhost/reports because it will then look for a default instance. Accessing it via the url that works is the right way to go.[/quote]
    Should I set up Production2005 as the default? I was told that http://localhost/reports - that exact URL - would get me in.
    [quote user="martins"]The reason for you not seeing any AdventureWorks reports is because they have not been deployed to your ReportServer. You will have to look for the Reporting Services project, open it and deploy the project to your ReportServer.[/quote]
    How do I do this? Again, complete newb, I can't see where in Studio or RM to do this.
    Appreciate the help so far!
    JB
  4. martins New Member

    No problem....we all have to start somewhere [:)]
    When you install SQL Server, you have the option to either install it as the default instance (without a name) or name the instance. This is usually needed if you want to have for argument sake 2 instances of SQL (and even different versions) on the same box...in order for you to be able to identify them. In the event of a default instance (with no name), the http://localhost/reports will get you in, but in the event that you have a named instance you will have to specify it with the instance name, ie http://localhost$<instance_name>/reports
    Please note that the we are talking about the instance of SQL and not the database. See books online for more details.
    If the Reporting Services samples were installed when either SQL Server or Reporting Services were installed, there would be a Reporting Services project file...usually in the C:program FilesMicrosoft SQL ServerMSSQLReporting ServicesSamples folder. Double clicking the .sln (solution) file will open the project in Business Intelligence Development Studio, from where you will have the different deployment options. If you do not have the project, download it from www.codeplex.com
    It will also be a good idea to go through the "How-To" articles for Reporting Services in Books Online.
  5. jaybee New Member

    Indeed, I'll be going through the BOL articles for RS (and later for IS), they do seem pretty good.
    We are definitely getting closer - I found and opened the AdventureWorksSampleReports.sln file, but for some reason, when I right-click on 'Deploy', VS doesn't connecting to the instance. It errors out, simply saying it can't connect to http://localhost/reportserver.
    I imagine I need to alter the connection details somewhere, but meantime, here's the detailed output from the message - doesn't give me much more clues:
    ===================================
    A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)
    ===================================
    The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
    ------------------------------
    Program Location:
    at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
    at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
    at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
    at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
    at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
    at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
    ===================================
    The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)
    ------------------------------
    Program Location:
    at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
    at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
    at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
  6. martins New Member

    Yip, you'll have to right click on the solution name (top right)...properties...and then change the TargetServerurl to reflect your instance name.
  7. jaybee New Member

    I'm having some annoying difficulties with this URL!
    Ok, given that the instance name is 'production2005', should the URL be http://localhost/production2005/reports ? If so, that URL doesn't connect.
  8. martins New Member

  9. jaybee New Member

    It doesn't like that:
    "Invalid URI: The hostname could not be parsed."
    I'm thinking there may be something in my IIS that isn't configured correctly - though I can't think what.
  10. martins New Member

    Type that url in your browser (on that box) and see if you get something. If you do, then it must be some other deployment setting and not IIS.
  11. martins New Member

  12. jaybee New Member

    (Checks Report Manager, then jumps up from PC, pours out a flute of Champagne, and sings, basso profundo,)
    "Weeeeeeee, are the champions, my friennnnnnnnnnnnnnd, we, are THE CHAMPIONS my friend!!"
    When you hit the club tonight Martin, tell the barman "Jaybee tab, code 1789". The drinks are on me!!
    :)

Share This Page