Reporting Services

I had SQL Reporting Services running on a test server and
have moved the databases over to a production server now,
replacing the default ReportServer and ReportServerTempDB
databases. However, when I try to run the reports through
IE on the new server I get the following error:
Reporting Services Error
---
--
The encrypted value for configuration setting Dsn cannot
be decrypted. (rsFailedToDecryptConfigInformation)
An internal error occurred on the report server. See the
error log for more details. (rsInternalError)
When I get online help about this (there's a link on the
error page that comes up), it says:
Explanation
The rsreportserver.config file stores encrypted values
that are used by the report server to connect to the
report server database. The values are encrypted using the
private key and public key of the computer. Encrypted
values include the data source name, connection string,
and credentials. This error occurs when one or more of
these values cannot be decrypted. Conditions that cause
this error to occur include configuration file corruption,
copying a configuration file for one computer to another,
performing a backup-and-restore operation that restores a
configuration file that is not valid for the current
computer. When this error occurs, the report server can no
longer connect to the report server database.
User Action
Run rsconfig utility to specify the encrypted connection
values used to connect to the report server database. For
more information this utility, search Books Online.
---
--
So, I run RSCONFIG through term. server with the following
command:
rsconfig -e -s \\xxx -a windows -d reportserver -u NT
Authority\Network Service
And I get the following error:
Error: HRESULT=0x8004F992 For more information, see the
event log in the Event Viewer.
I then check the Event Viewer and find the following:
Event Type: Error
Event Source: Report Server
Event Category: Management
Event ID: 129
Date: 5/10/2004
Time: 12:11:11 PM
User: N/A
Computer: xxx
Description:
The encrypted value for Configuration/LogonDomain in the
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file cannot be
decrypted.
====================================
I assume that my syntax is wrong for rsconfig, but I can't
figure it out. Can anyone offer a suggestion?
Thanks,
AndrewI am not an expert with Reporting Services by any means...but have you =tried to re-deploy the project? You will want to tell VS to overwrite =the data sources when deploying the project.
-- Keith
"Abn" <anonymous@.discussions.microsoft.com> wrote in message =news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
> I had SQL Reporting Services running on a test server and > have moved the databases over to a production server now, > replacing the default ReportServer and ReportServerTempDB > databases. However, when I try to run the reports through > IE on the new server I get the following error:
> > Reporting Services Error
> ---
> --
> > The encrypted value for configuration setting Dsn cannot > be decrypted. (rsFailedToDecryptConfigInformation) > An internal error occurred on the report server. See the > error log for more details. (rsInternalError) > > When I get online help about this (there's a link on the > error page that comes up), it says:
> > Explanation > The rsreportserver.config file stores encrypted values > that are used by the report server to connect to the > report server database. The values are encrypted using the > private key and public key of the computer. Encrypted > values include the data source name, connection string, > and credentials. This error occurs when one or more of > these values cannot be decrypted. Conditions that cause > this error to occur include configuration file corruption, > copying a configuration file for one computer to another, > performing a backup-and-restore operation that restores a > configuration file that is not valid for the current > computer. When this error occurs, the report server can no > longer connect to the report server database.
> > User Action > Run rsconfig utility to specify the encrypted connection > values used to connect to the report server database. For > more information this utility, search Books Online.
> > ---
> --
> > So, I run RSCONFIG through term. server with the following > command:
> > rsconfig -e -s \\xxx -a windows -d reportserver -u NT > Authority\Network Service
> > And I get the following error:
> > Error: HRESULT=3D0x8004F992 For more information, see the > event log in the Event Viewer.
> > I then check the Event Viewer and find the following:
> > Event Type: Error
> Event Source: Report Server
> Event Category: Management > Event ID: 129
> Date: 5/10/2004
> Time: 12:11:11 PM
> User: N/A
> Computer: xxx
> Description:
> The encrypted value for Configuration/LogonDomain in the > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting > Services\ReportServer\RSReportServer.config file cannot be > decrypted.
> ==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > I assume that my syntax is wrong for rsconfig, but I can't > figure it out. Can anyone offer a suggestion?
> > Thanks,
> > Andrew
>|||Thanks for the reply, Keith. I did try this, but it did
not work.
If you have any other ideas I'd love to hear them.
>--Original Message--
>I am not an expert with Reporting Services by any
means...but have you tried to re-deploy the project? You
will want to tell VS to overwrite the data sources when
deploying the project.
>--
>Keith
>
>"Abn" <anonymous@.discussions.microsoft.com> wrote in
message news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
>> I had SQL Reporting Services running on a test server
and
>> have moved the databases over to a production server
now,
>> replacing the default ReportServer and
ReportServerTempDB
>> databases. However, when I try to run the reports
through
>> IE on the new server I get the following error:
>> Reporting Services Error
>> ---
--
>> --
>> The encrypted value for configuration setting Dsn
cannot
>> be decrypted. (rsFailedToDecryptConfigInformation)
>> An internal error occurred on the report server. See
the
>> error log for more details. (rsInternalError)
>> When I get online help about this (there's a link on
the
>> error page that comes up), it says:
>> Explanation
>> The rsreportserver.config file stores encrypted values
>> that are used by the report server to connect to the
>> report server database. The values are encrypted using
the
>> private key and public key of the computer. Encrypted
>> values include the data source name, connection string,
>> and credentials. This error occurs when one or more of
>> these values cannot be decrypted. Conditions that cause
>> this error to occur include configuration file
corruption,
>> copying a configuration file for one computer to
another,
>> performing a backup-and-restore operation that restores
a
>> configuration file that is not valid for the current
>> computer. When this error occurs, the report server can
no
>> longer connect to the report server database.
>> User Action
>> Run rsconfig utility to specify the encrypted
connection
>> values used to connect to the report server database.
For
>> more information this utility, search Books Online.
>> ---
--
>> --
>> So, I run RSCONFIG through term. server with the
following
>> command:
>> rsconfig -e -s \\xxx -a windows -d reportserver -u NT
>> Authority\Network Service
>> And I get the following error:
>> Error: HRESULT=0x8004F992 For more information, see the
>> event log in the Event Viewer.
>> I then check the Event Viewer and find the following:
>> Event Type: Error
>> Event Source: Report Server
>> Event Category: Management
>> Event ID: 129
>> Date: 5/10/2004
>> Time: 12:11:11 PM
>> User: N/A
>> Computer: xxx
>> Description:
>> The encrypted value for Configuration/LogonDomain in
the
>> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportServer\RSReportServer.config file cannot
be
>> decrypted.
>> ====================================>> I assume that my syntax is wrong for rsconfig, but I
can't
>> figure it out. Can anyone offer a suggestion?
>> Thanks,
>> Andrew
>.
>