My FIrst Web Report Problem

  • Hi Specialists.

    I have created my first ever report in Microsoft Visual Studio and it works fine, however when i try to deploy this I get an error saying

    "Could not connect to the report server http:localhost/ReportServer"

    So i went back into configuration manager and tried clicking the url and it said in IE

    Reporting Services Error

    --------------------------------------------------------------------------------

    The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help

    Bad Data. (Exception from HRESULT: 0x80090005)

    --------------------------------------------------------------------------------

    SQL Server Reporting Services

    Please help

  • Do you have your SSRS keys backed up?

    Occasionally the key can become "lost" and you may need to restore it.

    Here is a link concerning the issue. The first post has a quick set of instructions on resolving it.

    http://connect.microsoft.com/SQLServer/feedback/details/322557/the-report-server-cannot-decrypt-the-symmetric-key

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thanks for that, that was a big help I am a little further. I have created the report and managed to pre-view it but once I go to delpoy it I am faced with a new error

    The permissions granted to user 'data\alan' are insufficient for performing this operation.00

  • ok I seem to have got a little further with the deploy thing past the permissions problem I am now facing another problem which is

    Cannot deploy the report because the shared data source '/Data Sources/MyFirstREP' that the report references does not exist on the report server.

    C:\Users\alan\Documents\Visual Studio 2008\projects\MyFIrstReport\MyFIrstReport\bin\Debug\Report1.rdl

    ohhh my head im off to bed, had enough for today

    thanks

    Alan

  • alan_lynch (3/8/2013)


    ok I seem to have got a little further with the deploy thing past the permissions problem I am now facing another problem which is

    Cannot deploy the report because the shared data source '/Data Sources/MyFirstREP' that the report references does not exist on the report server.

    C:\Users\alan\Documents\Visual Studio 2008\projects\MyFIrstReport\MyFIrstReport\bin\Debug\Report1.rdl

    ohhh my head im off to bed, had enough for today

    thanks

    Alan

    Looks like you are making good progress really.

    This last error is that you are using a "shared" datasource instead of an imbedded datasource. Deploy the datasource to the ReportServer and you will be all the closer.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Hi Jason.

    Thanks for that its all working now. I just need to work on tidying my reports up and granting permissions to various users.

    Thanks again

    Alan

  • Good to hear. Thanks for the feedback.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 7 posts - 1 through 6 (of 6 total)

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