Security/Connection Issue?...

  • Hi.

    I have setup a reporting server on SQL Server 2000 Reporting Services and have uploaded several reports and I'm able to view them on the server.

    But I have trouble trying to get a client machine to view the reports over the network. The client is able to view the report names from the list, but once I click to navigate to the report the 'This page cannot be displayed' error appears. There isn't the error where it says you don't have permission to view this report... so I'm wondering whether there's a setting on the server or client machine that I've overlooked.

    The client does have suffient permission both on the SQL Server database as well as 'Content Manager' permissions via the reporting services interface.

    Is there an application/security layer when navigating from the report list to the actual report itself because this seems to be where the problem appears.

    Thanks,

    Dave

  • To my knowledge there is not another security level, if the user has permissions to browse and as content manager they should be able to view the reports themselves.

    What browser and version are you using?

  • I'm using Internet Explorer 7.0... I don't think I should need any plug-ins to view the reports should I?

    The version of Reporting Services I'm using is for SQL Server 2000, developing with Visual Studio 2003.

    Regards,

    Dave

  • generally, all sp's or table's grant the execute or select permission to public, so that client can access the data because of select or execute permission.

    check the permissions of objects.

  • Can you check the security on the ReportServer virtual directory in IIS? I think I had this happen, but it was years ago, 2001-2002, and I don't recall what the issue was.

    Can anyone view the reports from their desktop/laptop?

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

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