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.
--=20
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=20
> have moved the databases over to a production server now,=20
> replacing the default ReportServer and ReportServerTempDB=20
> databases. However, when I try to run the reports through=20
> IE on the new server I get the following error:
>=20
> Reporting Services Error
> ---
> --
> =20
> The encrypted value for configuration setting Dsn cannot=20
> be decrypted. (rsFailedToDecryptConfigInformation)=20
> An internal error occurred on the report server. See the=20
> error log for more details. (rsInternalError)=20
>=20
> When I get online help about this (there's a link on the=20
> error page that comes up), it says:
>=20
> Explanation=20
> The rsreportserver.config file stores encrypted values=20
> that are used by the report server to connect to the=20
> report server database. The values are encrypted using the=20
> private key and public key of the computer. Encrypted=20
> values include the data source name, connection string,=20
> and credentials. This error occurs when one or more of=20
> these values cannot be decrypted. Conditions that cause=20
> this error to occur include configuration file corruption,=20
> copying a configuration file for one computer to another,=20
> performing a backup-and-restore operation that restores a=20
> configuration file that is not valid for the current=20
> computer. When this error occurs, the report server can no=20
> longer connect to the report server database.
> =20
> User Action=20
> Run rsconfig utility to specify the encrypted connection=20
> values used to connect to the report server database. For=20
> more information this utility, search Books Online.
>=20
> ---
> --
> =20
> So, I run RSCONFIG through term. server with the following=20
> command:
>=20
> rsconfig -e -s \\xxx -a windows -d reportserver -u NT=20
> Authority\Network Service
>=20
> And I get the following error:
>=20
> Error: HRESULT=3D0x8004F992 For more information, see the=20
> event log in the Event Viewer.
>=20
> I then check the Event Viewer and find the following:
>=20
> Event Type: Error
> Event Source: Report Server
> Event Category: Management=20
> 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=20
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting=20
> Services\ReportServer\RSReportServer.config file cannot be=20
> 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=3Dseagreen">
>=20
> I assume that my syntax is wrong for rsconfig, but I can't=20
> figure it out. Can anyone offer a suggestion?
>=20
> Thanks,
>=20
> 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...
and[vbcol=seagreen]
now,[vbcol=seagreen]
ReportServerTempDB[vbcol=seagreen]
through[vbcol=seagreen]
--[vbcol=seagreen]
cannot[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
corruption,[vbcol=seagreen]
another,[vbcol=seagreen]
a[vbcol=seagreen]
no[vbcol=seagreen]
connection[vbcol=seagreen]
For[vbcol=seagreen]
--[vbcol=seagreen]
following[vbcol=seagreen]
the[vbcol=seagreen]
be[vbcol=seagreen]
can't[vbcol=seagreen]
>.
>

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
>.
>

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,
Andrew
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.
--=20
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=20
> have moved the databases over to a production server now,=20
> replacing the default ReportServer and ReportServerTempDB=20
> databases. However, when I try to run the reports through=20
> IE on the new server I get the following error:
>=20
> Reporting Services Error
> --
> =20
> The encrypted value for configuration setting Dsn cannot=20
> be decrypted. (rsFailedToDecryptConfigInformation)=20
> An internal error occurred on the report server. See the=20
> error log for more details. (rsInternalError)=20
>=20
> When I get online help about this (there's a link on the=20
> error page that comes up), it says:
>=20
> Explanation=20
> The rsreportserver.config file stores encrypted values=20
> that are used by the report server to connect to the=20
> report server database. The values are encrypted using the=20
> private key and public key of the computer. Encrypted=20
> values include the data source name, connection string,=20
> and credentials. This error occurs when one or more of=20
> these values cannot be decrypted. Conditions that cause=20
> this error to occur include configuration file corruption,=20
> copying a configuration file for one computer to another,=20
> performing a backup-and-restore operation that restores a=20
> configuration file that is not valid for the current=20
> computer. When this error occurs, the report server can no=20
> longer connect to the report server database.
> =20
> User Action=20
> Run rsconfig utility to specify the encrypted connection=20
> values used to connect to the report server database. For=20
> more information this utility, search Books Online.
>=20
> --
> =20
> So, I run RSCONFIG through term. server with the following=20
> command:
>=20
> rsconfig -e -s \\xxx -a windows -d reportserver -u NT=20
> Authority\Network Service
>=20
> And I get the following error:
>=20
> Error: HRESULT=3D0x8004F992 For more information, see the=20
> event log in the Event Viewer.
>=20
> I then check the Event Viewer and find the following:
>=20
> Event Type: Error
> Event Source: Report Server
> Event Category: Management=20
> 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=20
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting=20
> Services\ReportServer\RSReportServer.config file cannot be=20
> decrypted.
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=20
> I assume that my syntax is wrong for rsconfig, but I can't=20
> figure it out. Can anyone offer a suggestion?
>=20
> Thanks,
>=20
> 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...[vbcol=seagreen]
and[vbcol=seagreen]
now,[vbcol=seagreen]
ReportServerTempDB[vbcol=seagreen]
through[vbcol=seagreen]
--[vbcol=seagreen]
cannot[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
corruption,[vbcol=seagreen]
another,[vbcol=seagreen]
a[vbcol=seagreen]
no[vbcol=seagreen]
connection[vbcol=seagreen]
For[vbcol=seagreen]
--[vbcol=seagreen]
following[vbcol=seagreen]
the[vbcol=seagreen]
be[vbcol=seagreen]
can't
>.
>

Reporting Server replacing IP address with ComputerName

Hello,
I am facing a strange situation with my reports server.
The machine i am testing the server on has no domain name, only IP.
But, of course, it has a computer name.
When i access the report server manager, i get everything as it should
be, and it shows me the links to the reports, but when i want to see
the report, the report manager replaces IP in the report address, with
the computer name - which makes no sense since i am accessing the
server using the internet.
Hence, i am getting an 404 in the report sub-page.
If i copy the url from there, and go to the page after changing the
computer name to the IP, it works, naturally.
Does anybody know how to change this behavior?
Thanks in advance! :-)
ShlomoYes you need to see this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
Scroll down to the section that says "Deploying a Report Server for Internet
Access"
=-Chris
<shlomoid@.gmail.com> wrote in message
news:1108301192.984825.325330@.o13g2000cwo.googlegroups.com...
> Hello,
> I am facing a strange situation with my reports server.
> The machine i am testing the server on has no domain name, only IP.
> But, of course, it has a computer name.
> When i access the report server manager, i get everything as it should
> be, and it shows me the links to the reports, but when i want to see
> the report, the report manager replaces IP in the report address, with
> the computer name - which makes no sense since i am accessing the
> server using the internet.
> Hence, i am getting an 404 in the report sub-page.
> If i copy the url from there, and go to the page after changing the
> computer name to the IP, it works, naturally.
> Does anybody know how to change this behavior?
>
> Thanks in advance! :-)
> Shlomo
>|||Thanks!
Worked perfectly.