|
|
You're in the
sql server reporting services
group:Reporting Services Newbie
sql server reporting services:
I was intending to develop reports using Crystal but I thought I'd first take a look at Reporting services. I never used before so you'll have to bear with me. Im trying to work through a Books Online Tutorial. All is fairly straightforward, until I come to publish the report. Im getting the following error "The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)" Im not really sure what is going on here and the info Ive found on web has not helped. Ive checked my services and "SQL Server Reporting Services (MSSQLSERVER)" is Started. The Log On account is "Local System Account" - This is unchanged from installation. Also, as far as I can tell, the report does not contain any encryped data. The report is a simple grouped report based on the following SQL (adventureworks) SELECT S.OrderDate, S.SalesOrderNumber, S.TotalDue, C.FirstName, C.LastName FROM HumanResources.Employee E INNER JOIN Person.Contact C ON E.ContactID = C.ContactID INNER JOIN Sales.SalesOrderHeader S ON E.EmployeeID = S.SalesPersonID A more general question that I have is whether reporting services is a replacement for Crystal. Will I be able to generate reports with subreports. Will I be able to access them from my web app and will I be able to have my app pdf them and attach them to emails? If so, are there tutorials available for these uses of reporting services? All help appreciated
[quoted text, click to view] > "The report server cannot decrypt the symmetric key used to access sensitive > or encrypted data in a report server database. You must either restore a > backup key or delete all encrypted content. Check the documentation for more > information. (rsReportServerDisabled)" OK, Ive managed to resolve this by doing the following suggestion found in another post: go to commna prompt go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn you should find rskeymgmt,rsconfig etc etc from this location do this --> "rsKeyMgmt -d" This deletes all the old symmetric keys Then restart your IIS then go back to the command prompt and do "rsconfig -e -u (domain\username) -p (password)" This will create the encrypted symmetric keys again. The user name and password to use are the ones the report server is running under. (maybe your windows account). I set the SQL Reporting Service to run under my Admin account ie changed it from System account (Im not sure what account best practice says this service, or any of the other SQL services, should run under - could someone advise) [quoted text, click to view] > A more general question that I have is whether reporting services is a > replacement for Crystal. Will I be able to generate reports with subreports. > Will I be able to access them from my web app and will I be able to have my > app pdf them and attach them to emails? If so, are there tutorials available > for these uses of reporting services? Having had a bit of a play, I can see that SQL Reporting Services has huge potential for our organisation. Initially my main task would be to get to grips with the ASP ReportViewer control and programmatically setting parameter values for reports. I'd really appreciated some pointers for decent books, online resources that show 'real' examples of using Reporting
Terry,
Check out http://www.gotreportviewer.com/. It is the most comprehensive report viewer control site around. There is also a newsgroup dedicated to the controls here: http://forums.microsoft.com/msdn/showforum.aspx?forumid=75&siteid=1 -- Andy Potter blog: http://sqlreportingservices.spaces.live.com/ [quoted text, click to view] "Terry Holland" wrote:
> > > "The report server cannot decrypt the symmetric key used to access sensitive > > or encrypted data in a report server database. You must either restore a > > backup key or delete all encrypted content. Check the documentation for more > > information. (rsReportServerDisabled)" > > OK, Ive managed to resolve this by doing the following suggestion found in > another post: > > go to commna prompt > go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn > you should find rskeymgmt,rsconfig etc etc > from this location do this --> "rsKeyMgmt -d" > This deletes all the old symmetric keys > Then restart your IIS > then go back to the command prompt and do "rsconfig -e -u (domain\username) > -p (password)" > This will create the encrypted symmetric keys again. > The user name and password to use are the ones the report server is running > under. (maybe your windows account). > > I set the SQL Reporting Service to run under my Admin account ie changed it > from System account (Im not sure what account best practice says this > service, or any of the other SQL services, should run under - could someone > advise) > > > A more general question that I have is whether reporting services is a > > replacement for Crystal. Will I be able to generate reports with subreports. > > Will I be able to access them from my web app and will I be able to have my > > app pdf them and attach them to emails? If so, are there tutorials available > > for these uses of reporting services? > > Having had a bit of a play, I can see that SQL Reporting Services has huge > potential for our organisation. Initially my main task would be to get to > grips with the ASP ReportViewer control and programmatically setting > parameter values for reports. I'd really appreciated some pointers for > decent books, online resources that show 'real' examples of using Reporting
I found the Step by Step book for Reporting Services 2005 gave a good
introduction. Microsoft SQL Server 2005 Reporting Services Step By Step ISBN: 0735622507 amazon link: http://www.amazon.com/Microsoft-Server-2005-Reporting-Services/dp/0735622507/ref=sr_1_5/103-1359644-0587846?ie=UTF8&s=books&qid=1175393092&sr=1-5 [quoted text, click to view] "Terry Holland" <MSDNNospam248@nospam.nospam> wrote in message news:CBC4ECC2-1023-4449-9838-5577A9C3B17C@microsoft.com... > >> "The report server cannot decrypt the symmetric key used to access >> sensitive >> or encrypted data in a report server database. You must either restore a >> backup key or delete all encrypted content. Check the documentation for >> more >> information. (rsReportServerDisabled)" > > OK, Ive managed to resolve this by doing the following suggestion found in > another post: > > go to commna prompt > go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn > you should find rskeymgmt,rsconfig etc etc > from this location do this --> "rsKeyMgmt -d" > This deletes all the old symmetric keys > Then restart your IIS > then go back to the command prompt and do "rsconfig -e -u > (domain\username) > -p (password)" > This will create the encrypted symmetric keys again. > The user name and password to use are the ones the report server is > running > under. (maybe your windows account). > > I set the SQL Reporting Service to run under my Admin account ie changed > it > from System account (Im not sure what account best practice says this > service, or any of the other SQL services, should run under - could > someone > advise) > >> A more general question that I have is whether reporting services is a >> replacement for Crystal. Will I be able to generate reports with >> subreports. >> Will I be able to access them from my web app and will I be able to have >> my >> app pdf them and attach them to emails? If so, are there tutorials >> available >> for these uses of reporting services? > > Having had a bit of a play, I can see that SQL Reporting Services has huge > potential for our organisation. Initially my main task would be to get to > grips with the ASP ReportViewer control and programmatically setting > parameter values for reports. I'd really appreciated some pointers for > decent books, online resources that show 'real' examples of using > Reporting > Services within an ASP application
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |