If I use the URL 'http://my.rportingserver.com/ReportServer', I am presented
with a list of the directory contents, as if Directory Browsing were turned
on for the directory in IIS. At the bottom of the directory listing, is an
indication that this is a Reporting Services function:
Microsoft SQL Server Reporting Services Version 9.00.1314.00
Needless to say, Directory Browsing is turned off in InetMgr. What controls
this directory listing, and can it be turned off ?
Thanks !Report manager is the front for RS. So you will see a listing inspite of
turning off directory browsing. Basically to access all the reports it is
provided if you dont want the listing to be displayed, then remove the access
rights "Read" (I think it is browse) from the configuration.
Amarnath
"RJ" wrote:
> If I use the URL 'http://my.rportingserver.com/ReportServer', I am presented
> with a list of the directory contents, as if Directory Browsing were turned
> on for the directory in IIS. At the bottom of the directory listing, is an
> indication that this is a Reporting Services function:
> Microsoft SQL Server Reporting Services Version 9.00.1314.00
> Needless to say, Directory Browsing is turned off in InetMgr. What controls
> this directory listing, and can it be turned off ?
> Thanks !
Showing posts with label reportserver. Show all posts
Showing posts with label reportserver. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
Reporting Services 2005 : The report server cannot open a connection to the report server databa
Hi,
I am getting the following error whenever I try to open the reportserver 2005 default web page
http://home/reportserver
Reporting Services Error
--
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
--
SQL Server Reporting Services
SQL SERVER 2005 DEVELOPER EDITION ERROR LOG
2006-01-24 17:54:52.65 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
REPORTING SERVICES 2005 ERROR LOG
aspnet_wp!runningjobs!15!1/24/2006-18:41:26:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
SURFACE AREA CONFIGURATION TOOL
SQL Server 2005 -> Reporting Services -> Integrated Security hangs 60 seconds
Next, long error stack trace follows with a message near the beginning ...
The report server can not open a connection to the SQL Server database.
All of my instances are up and running.
All of my instances allow both Windows Authentication and SQL Server Authentication.
Each has an sa password. (They are all the same.) I have tested each and can connect to each instance.
All of my instances allow remote connections. I have up'ed the connection timeout to 60 seconds.
Any ideas?
Any place that I could look to find SQL Server 2005 Reporting Services database connection Troubleshooting documentation?
Thank you very much.
AIMDBA
This error sounds like reporting services cannot communicate to the reportservices database, which is just a standard sql server 2005 database. Are you hosting the database server and reporting services on the same physical machine?|||JonM,
Yes, I am hosting SQL Server 2005 Developers Edition database edition and SQL Server 2005 Reporting Services Developer Edition reporting server on the same machine. I just went through the regular install.
Any directions to try to start debugging this problem?
AIMDBA
|||The first thing to do is to go the 'Reporting Services Configuration Manager' Please make sure there is a green check mark next to everything (except encryption keys and execution accounts). Many common problems can be diagnosed here. Specifically make sure the 'Database Setup' looks correct.|||Yes,
The SQL Server 2005 Developer Edition Report Server and the SQL Server 2005 Developer Edition Database Server are on the same machine.
I also did the following ...
Went into Report Server configuration ...
Set and Tested the login creditions to be
SQL Server Credentials
.
SA
password
I used a . for the local database. That all worked fine.
Next, I changed the Execution Account to be .\Administrator.
That seems O.K.
Next, I changes the Reporting Services Service to run under .\Administrator.
I shut down and restarted everything.
When I do : http://localhost/reportserver
Now, I get a new message:
Reporting Services Error
The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) Get Online Helpsql
Reporting Services 2005 : The report server cannot open a connection to the report server databa
Hi,
I am getting the following error whenever I try to open the reportserver 2005 default web page
http://home/reportserver
Reporting Services Error
--
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
--
SQL Server Reporting Services
SQL SERVER 2005 DEVELOPER EDITION ERROR LOG
2006-01-24 17:54:52.65 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
REPORTING SERVICES 2005 ERROR LOG
aspnet_wp!runningjobs!15!1/24/2006-18:41:26:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
SURFACE AREA CONFIGURATION TOOL
SQL Server 2005 -> Reporting Services -> Integrated Security hangs 60 seconds
Next, long error stack trace follows with a message near the beginning ...
The report server can not open a connection to the SQL Server database.
All of my instances are up and running.
All of my instances allow both Windows Authentication and SQL Server Authentication.
Each has an sa password. (They are all the same.) I have tested each and can connect to each instance.
All of my instances allow remote connections. I have up'ed the connection timeout to 60 seconds.
Any ideas?
Any place that I could look to find SQL Server 2005 Reporting Services database connection Troubleshooting documentation?
Thank you very much.
AIMDBA
This error sounds like reporting services cannot communicate to the reportservices database, which is just a standard sql server 2005 database. Are you hosting the database server and reporting services on the same physical machine?|||JonM,
Yes, I am hosting SQL Server 2005 Developers Edition database edition and SQL Server 2005 Reporting Services Developer Edition reporting server on the same machine. I just went through the regular install.
Any directions to try to start debugging this problem?
AIMDBA
|||The first thing to do is to go the 'Reporting Services Configuration Manager' Please make sure there is a green check mark next to everything (except encryption keys and execution accounts). Many common problems can be diagnosed here. Specifically make sure the 'Database Setup' looks correct.|||Yes,
The SQL Server 2005 Developer Edition Report Server and the SQL Server 2005 Developer Edition Database Server are on the same machine.
I also did the following ...
Went into Report Server configuration ...
Set and Tested the login creditions to be
SQL Server Credentials
.
SA
password
I used a . for the local database. That all worked fine.
Next, I changed the Execution Account to be .\Administrator.
That seems O.K.
Next, I changes the Reporting Services Service to run under .\Administrator.
I shut down and restarted everything.
When I do : http://localhost/reportserver
Now, I get a new message:
Reporting Services Error
The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) Get Online Help
Friday, March 23, 2012
reporting services 2000 and 2005 - same database server
We have reporting services 2000 running, with the reportserver and
reportservertemp databases on sql server 2005 on another machine. I
wanted to install reporting services 2005 on a separte machine (3rd
machine), but create the system report server databases (with
different names) on the same sql server as the current database
server, where reporting services 2000 system databases are present.
I installed reporting services, and when I use the configuration tool
to make the database setup, I'm getting the error that the databases
cannot be created, probably because I do not have sufficient
permissions. In spite of this message, the databases are created on
the server. I am the local administrator the sql server machine and
the machine on which I am trying to install reporting services 2005.
Also I am sysadmin on sql server.
When I try to set up the reporting services system databases on a
different sql server it works fine. So my question is whether it is
not possible to install system databases of 2000 and 2005 reporting
services on a single sql server 2005 database server? If yes, can you
please recomment some troubleshooting tips?
Thanks,
JohnIt does not seem to be a problem of two different versions of
reporting services databases on the same sql server. On further
testing, I found that I can set the reporting services system
databases on some remote database servers and not on some; whether the
database server already has a reporting service system database
doesn't seem to be causing the error.
Still looking for ways to troubleshoot.
John|||I figured what was the problem. First I used the reporting services
configuration tool to generate the scripts, and then ran the scripts
on the database server. The problem is that the reporting services
2005 sp2 configuration tool created script is not perfect, if the
system database is named other than ReportServer.
Portion of the generated script is attached below. Note that the
system database I specified was ReportServer2005 and so the other db
would be ReportServer2005TempDB. Now towards the end of the script,
note that it is referring to ReportServerTempdb, instead of
ReportServer2005TempDB, and that was really giving the error. Can't
believe Microsoft could had messed up like that!
IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name =N'ReportServer2005') CREATE DATABASE [ReportServer2005] COLLATE
Latin1_General_CI_AS_KS_WS
GO
IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name =N'ReportServer2005TempDB') CREATE DATABASE [ReportServer2005TempDB]
COLLATE Latin1_General_CI_AS_KS_WS
GO
...
ELSE BEGIN
INSERT INTO [ReportServerTempdb].[dbo].[ChunkData] (
ChunkId, SnapshotDataId, ChunkFlags, ChunkName,
ChunkType, Version, MimeType, Content )
SELECT
NEWID(), @.SnapshotId, @.ChunkFlags, @.ChunkName,
@.ChunkType, @.Version, @.MimeType, ISNULL(Linked.Content,
Original.Content)
FROM [Catalog] Original
LEFT OUTER JOIN [Catalog] Linked WITH (INDEX(PK_Catalog)) ON
(Original.LinkSourceId = Linked.ItemId)
WHERE Original.ItemId = @.ItemId AND
NOT EXISTS (
SELECT *
FROM [ReportServerTempdb].[dbo].[ChunkData]
WHERE SnapshotDataId = @.SnapshotId AND
ChunkName = @.ChunkName AND
ChunkType = @.ChunkType )
END
reportservertemp databases on sql server 2005 on another machine. I
wanted to install reporting services 2005 on a separte machine (3rd
machine), but create the system report server databases (with
different names) on the same sql server as the current database
server, where reporting services 2000 system databases are present.
I installed reporting services, and when I use the configuration tool
to make the database setup, I'm getting the error that the databases
cannot be created, probably because I do not have sufficient
permissions. In spite of this message, the databases are created on
the server. I am the local administrator the sql server machine and
the machine on which I am trying to install reporting services 2005.
Also I am sysadmin on sql server.
When I try to set up the reporting services system databases on a
different sql server it works fine. So my question is whether it is
not possible to install system databases of 2000 and 2005 reporting
services on a single sql server 2005 database server? If yes, can you
please recomment some troubleshooting tips?
Thanks,
JohnIt does not seem to be a problem of two different versions of
reporting services databases on the same sql server. On further
testing, I found that I can set the reporting services system
databases on some remote database servers and not on some; whether the
database server already has a reporting service system database
doesn't seem to be causing the error.
Still looking for ways to troubleshoot.
John|||I figured what was the problem. First I used the reporting services
configuration tool to generate the scripts, and then ran the scripts
on the database server. The problem is that the reporting services
2005 sp2 configuration tool created script is not perfect, if the
system database is named other than ReportServer.
Portion of the generated script is attached below. Note that the
system database I specified was ReportServer2005 and so the other db
would be ReportServer2005TempDB. Now towards the end of the script,
note that it is referring to ReportServerTempdb, instead of
ReportServer2005TempDB, and that was really giving the error. Can't
believe Microsoft could had messed up like that!
IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name =N'ReportServer2005') CREATE DATABASE [ReportServer2005] COLLATE
Latin1_General_CI_AS_KS_WS
GO
IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name =N'ReportServer2005TempDB') CREATE DATABASE [ReportServer2005TempDB]
COLLATE Latin1_General_CI_AS_KS_WS
GO
...
ELSE BEGIN
INSERT INTO [ReportServerTempdb].[dbo].[ChunkData] (
ChunkId, SnapshotDataId, ChunkFlags, ChunkName,
ChunkType, Version, MimeType, Content )
SELECT
NEWID(), @.SnapshotId, @.ChunkFlags, @.ChunkName,
@.ChunkType, @.Version, @.MimeType, ISNULL(Linked.Content,
Original.Content)
FROM [Catalog] Original
LEFT OUTER JOIN [Catalog] Linked WITH (INDEX(PK_Catalog)) ON
(Original.LinkSourceId = Linked.ItemId)
WHERE Original.ItemId = @.ItemId AND
NOT EXISTS (
SELECT *
FROM [ReportServerTempdb].[dbo].[ChunkData]
WHERE SnapshotDataId = @.SnapshotId AND
ChunkName = @.ChunkName AND
ChunkType = @.ChunkType )
END
Reporting Services (Page Issue)
I have created a report in visual studio 2005, using the reportserver. I am able to create the report as a pdf, but for somereason, data is begin shown on every other page.
Does anyone know what might cause this?
Before deploying the report have a look at it in preview mode sounds like you may have a margin applied that is increasing the overall width of your page and causing it to go onto the next page|||Thank you. That was the problemWednesday, March 21, 2012
Reporting Services - Port Number
Hi,
I have managed to get reporting services working, my reports and reportserver sites are not under the default site but under a custom site i have created, this site has been configured for port 8089. Reporting services for the most part is working fine but several of the links and buttons which navigate to a different pages getting the port number 8089 added to the end of the link which is causing the page to not be found why are these being added and how can i stop this port from being added. If i remove the port number then the correct page is displayed.
The URL within the two config files associated with reporting services does not have the port number, i use ISA to redirect to the port 8089.
Thanks and Regards,
Hi,
Heres some info. i recieved:
Tips on Changing the port number:
Part 1: IIS Configuration
Note: IIS routes incoming URL requests to the appropriate place based upon matching the URL's Host (DNS Name or IP Address) and Port (defaults to 80) to the IIS Web Site whose identity matches or accepts these parameters of the URL. The IP address of the URL's Host, the Port, and the Host header value (when multiple Domain Names map to the same IP address / server) must match. The default configuration is for the default web site to accept all un-matched URLs requested on port 80.
A. Modifying the IIS Web Site Identity - Open the IIS Manager, select a web site object, and click Properties. The Web Site Identification is configured in the "Web Site" tab of the Web Site Properties dialog.
- If a server hosts more than one domain name then create a new web site specifying a host header that matches a domain name
- If a port besides 80 required in the URL then configure the TCP port(s) of the web site to match the port required. From a client, the URL will require the port to be specified as follows: http://host:port/path
B. Modifying the SQL Server Reporting Services - Report Manager URL / path and Report Server Web Service URL / Path. These are assumed to be "/Reports" and "/ReportServer" respectively, but they can be changed or even created manually.
- The Report manager always uses the Report Server Web Service, so if http://host:port/<report server> does not work then http://host:port/<report manager> will not work.
- The Report manager must be configured to reference the correct URL to the Report Server Web Service (see part 2 below).
- The following two web sites describe how to create or move these virtual directories:
KB Article 867872 You receive a 1603 error message or a 25619 error message when you try to install SQL Server 2000 Reporting Services
<http://support.microsoft.com/?id=867872>
Moving Reporting Services' Virtual Directories
<http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk>
Part 2: SQL Server Reporting Services Configuration
- The RsWebApplication.Config file in the ReportManager folder contains a Configuration\UI\ReportServerUrl tag whose value is the URL to the <report server> web site. This value needs to be configured to match the URL to the <report server> virtual directory specified above.
Also if you are doing port redirection in ISA, try turning this off after going through the above steps as the two may be conflicting with each other.
Tuesday, March 20, 2012
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]
>.
>
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]
>.
>
Monday, March 12, 2012
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
>.
>
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
>.
>
Subscribe to:
Posts (Atom)