March 7, 2013 at 10:15 pm
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
March 7, 2013 at 10:35 pm
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.
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
March 8, 2013 at 3:45 am
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
March 8, 2013 at 5:11 am
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
March 8, 2013 at 8:57 am
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 isCannot 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
March 10, 2013 at 7:41 pm
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
March 10, 2013 at 10:49 pm
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