Reporting Services Newbie

Im developing an asp.net 2.0 application which has SQL 2005 at the backend.
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> "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|||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/
"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
> Services within an ASP application|||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
"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 applicationsql