Friday, March 23, 2012

Report Viewer Cannot Connect to Report Server VWD

Using VWD I am trying to use the report viewer to display a report that i have on my sql 2005 report server.

I AM Able get to the report server page by going to the site's ipaddress\reports

the report i want to display is in a folder

so when adding the report to the reportviewer control in VWD i put

ipaddress\reports for the server url

then I put foldername\reportname for the report path

the report never shows up in design mode and when i try to view the page in a browser

I keep getting

  • The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
  • The request failed with HTTP status 404: Not Found.
  • Well for one you have your slash backwards.

    It should behttp://myserver/reportserver

    Not '\'

    |||How I wish my problem was that simple, but i just mistyped it here. I really do have the correct / in my data.|||

    Just an idea, but try using the hostname of the server instead of the IP address. If you can type in a browser,

    http://myserver/ReportServer

    and get a response, your control will work.

    |||I don't have a host name set up for this site, hence why i am using the ip.

    Have you used report server with VWD and report viewer?

    Any other ideas...|||If you typehttp://ipaddress/reportserver into a web browser, do you get anything?|||

    yes first it prompts me for user name and password right now i enter the local server username and password

    after i do that i get the folders on the site like below do i need to pass the username and password to the report server some how?

    Thanks for your help!

     Thursday, September 28, 2006 11:10 AM <dir>Data Sources Thursday, September 28, 2006 11:10 AM <dir>Models Tuesday, October 03, 2006 7:37 AM <dir>Report Project1 Thursday, September 28, 2006 8:19 AM <dir>SMCReports

    Microsoft SQL Server Reporting Services Version 9.00.2047.00

    |||

    So the url you're using is:

    http://192.168.0.238:81/reportserver?%2fSMCReports%2fReportName

    Right?

    |||This may or may not help:http://www.dezel.com/articles/ReportingServicesRendering.html|||

    I got it it was a combination of things for one i was not using a / in the report path
    i just had smcreports/reportname instead of /smcreports/reportname.
    I also did not have the proper permissions set up in report manager

    I changed them according to this post

    thanks for the help!!!


    http://groups.google.com/group/microsoft.public.crm/browse_thread/thread/3b65374f40d44b12/a556ebab49a7b562?lnk=st&q=The+permissions+granted+to+user+%27NT+AUTHORITY%5CNETWORK+SERVICE%27+are+insufficient+for+performing+this+operation.+(rsAccessDenied)+&rnum=2&hl=en#a556ebab49a7b562

    NOTE: At this point you should be able to use Internet Explorer and browse
    the reports and reportserver virtual folders. Test this by going to
    http://SBSserverName/reports andhttp://SBSserverName/reportserver. You
    should be able to do this without receiving an error. If you receive an
    error please stop here and send us the error you get.


    4. Publish reports by opening a command prompt and going to:
    c:\program files\microsoft crm\reports
    Then run the following: publishreports.exe "company name"
    "Domain\ReportingGroup {GUID}"


    5. Give reports correct permissions
    a. From the default website where SRS is installed browse the
    reports directory (http://SBSserverName/reports)
    b. Click Properties then click Your_Org_Name_mscrm folder
    c. click the Security tab
    d. The following groups should be added:


    BUILTIN\Administrators with a role ofContent Manager
    DOMAINNAME\ReportingGroup
    {ec70ac7b-a091-4d00-b038-75fd6ea0e84c} with a role of Browser for Microsoft
    CRM
    NT AUTHORITY\NETWORK SERVICE with a role of Publisher for
    Microsoft CRM


    NOTE: If any of the above groups are missing you will need to
    add them.


    6. You may also have to do the steps on page 15-6 in the Microsoft CRM 3.0
    Implementation Guide
    http://www.microsoft.com/downloads/details.aspx?FamilyID=1FF067F8-4F7...
    AE9C-68ADA7D4F16A&displaylang=en

  • No comments:

    Post a Comment