Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


My FIrst Web Report Problem


My FIrst Web Report Problem

Author
Message
Oracle765
Oracle765
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 214
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
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21071 Visits: 18259
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

Oracle765
Oracle765
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 214
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.      0   0
Oracle765
Oracle765
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 214
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
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21071 Visits: 18259
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

Oracle765
Oracle765
SSC-Enthusiastic
SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)SSC-Enthusiastic (130 reputation)

Group: General Forum Members
Points: 130 Visits: 214
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
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21071 Visits: 18259
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

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search