InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 20:00:42 GMT20http://www.sqlservercentral.com/Forums/Topic1428383-147-1.aspxGood to hear. Thanks for the feedback.Sun, 10 Mar 2013 22:49:24 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1428383-147-1.aspxHi 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 againAlanSun, 10 Mar 2013 19:41:26 GMTalan_lynchhttp://www.sqlservercentral.com/Forums/Topic1428383-147-1.aspx[quote][b]alan_lynch (3/8/2013)[/b][hr]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.rdlohhh my head im off to bed, had enough for todaythanksAlan[/quote]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.Fri, 08 Mar 2013 08:57:49 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1428383-147-1.aspxok 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.rdlohhh my head im off to bed, had enough for todaythanksAlanFri, 08 Mar 2013 05:11:50 GMTalan_lynchhttp://www.sqlservercentral.com/Forums/Topic1428383-147-1.aspxThanks 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 errorThe permissions granted to user 'data\alan' are insufficient for performing this operation. 0 0 Fri, 08 Mar 2013 03:45:15 GMTalan_lynchhttp://www.sqlservercentral.com/Forums/Topic1428383-147-1.aspxDo 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.[url]http://connect.microsoft.com/SQLServer/feedback/details/322557/the-report-server-cannot-decrypt-the-symmetric-key[/url]Thu, 07 Mar 2013 22:35:37 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1428383-147-1.aspxHi 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 IEReporting 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 HelpBad Data. (Exception from HRESULT: 0x80090005) --------------------------------------------------------------------------------SQL Server Reporting Services Please helpThu, 07 Mar 2013 22:15:54 GMTalan_lynch