Showing posts with label default. Show all posts

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

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

--
SQL Server Reporting Services

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.

Any ideas?

Any place that I could look to find SQL Server 2005 Reporting Services database connection Troubleshooting documentation?

Thank you very much.

AIMDBA

JonM,

Any directions to try to start debugging this problem?

AIMDBA

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

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

Wednesday, March 21, 2012

Reporting Services - Web Service URL

I have installed SQL SERVER Katmai with default settings but for some reason I cannot access the Reporting Services. When I go to the Reporting Services Configuration I cannot configure the WebService URL. I also cannot access http://<servername>/Reports or http://<servername>/ReportServer. Can someone tell me what the problem could be?

Is the SQL Server Reporting Services Windows Service running at all?

|||

Service is running, however, I cannot get into the ReportServer through the SQL Server Management Studio or Internet Explorer. All other services are operating fine. I even checked to make sure there were no IIS sites with the same name as Reports or ReportServer.

|||

Reporting services is behaving different, in the SQL Server Configuration manager the "log on" properties tab for the "Reporting Services" says that Account settings &c are managed by the Reporting Services Configuration tool and it shows a disabled button labeled "Not Installed".

In the Surface Area Configuration tool I get an "invalid namespace" error on all 3 Reporting services items, 2x for system.management and once for sqlsac.

And the Reporting Services Configuration tool freezes when I click the WebService URL option. The Report Manager URL does work, and so does the link to the web interface, using port 8080. Trying to add or edit the entries in the "multiple identities" list under the "advanced" tab however also results in the tool freezing.

And this is using XP Pro SP2.

|||

I am on Windows XP Pro with SP2 and I don't have any issues. You can use the Web Service URL link in the RS Configuration utility to change the port. Assuming you are running on port 8080, http://localhost:8080/reportserver should respond.

|||

I am using Vista Home Premium and the Reporting Services does not work even though the others services do. My next step is to upgrade to Vista Ultimate and put Kamai on my Windows 2003 Server. I understand that there are processing that don't work on the Home editions of Vista that work on the Business editions. I will report my findings.

|||

Vista is not officially supported with the July CTP. For better experience I'd recommend you stick with Windows XP .

|||

That is right, I had already seen that http://localhost:8080/reportserver did work. But I had to dig into some .config files to find that URL, as it didn't work via the Reporting Services Configuration tool. So, I still wonder what's causing the problems I described...

|||

Is therer something else listening on the original port (probably 80)? What does netstat -no show?

|||

Sure, the standard IIS webservice. Has to be there for the installation to run smoothly.It choked a few times when I had an Apache server active there. But that's all OK now. It's not the web interface that has problems. It's SAC and Reporting Services Config.

|||

You shouldn't need IIS running at all for installation to run (in fact, it is better to turn it off if you aren't using it). Are you sure you are using the latest CTP?

Reporting Services - Web Service URL

Is the SQL Server Reporting Services Windows Service running at all?

|||

In the Surface Area Configuration tool I get an "invalid namespace" error on all 3 Reporting services items, 2x for system.management and once for sqlsac.

And this is using XP Pro SP2.

|||

Vista is not officially supported with the July CTP. For better experience I'd recommend you stick with Windows XP .

|||

Is therer something else listening on the original port (probably 80)? What does netstat -no show?

|||

|||You shouldn't need IIS running at all for installation to run (in fact, it is better to turn it off if you aren't using it). Are you sure you are using the latest CTP?

Reporting Services - Web Service URL

Is the SQL Server Reporting Services Windows Service running at all?

|||

In the Surface Area Configuration tool I get an "invalid namespace" error on all 3 Reporting services items, 2x for system.management and once for sqlsac.

And this is using XP Pro SP2.

|||

Vista is not officially supported with the July CTP. For better experience I'd recommend you stick with Windows XP .

|||

Is therer something else listening on the original port (probably 80)? What does netstat -no show?

|||

|||You shouldn't need IIS running at all for installation to run (in fact, it is better to turn it off if you aren't using it). Are you sure you are using the latest CTP?

Reporting Services - Web Service URL

Is the SQL Server Reporting Services Windows Service running at all?

|||

In the Surface Area Configuration tool I get an "invalid namespace" error on all 3 Reporting services items, 2x for system.management and once for sqlsac.

And this is using XP Pro SP2.

|||

Vista is not officially supported with the July CTP. For better experience I'd recommend you stick with Windows XP .

|||

Is therer something else listening on the original port (probably 80)? What does netstat -no show?

|||

|||You shouldn't need IIS running at all for installation to run (in fact, it is better to turn it off if you aren't using it). Are you sure you are using the latest CTP?sql

Reporting Services - Web Service Credentials

Dim objRptServ As New ReportingService
'Assign default credentials for web service access
objRptServ.Credentials = System.Net.CredentialCache.DefaultCredentials
Guys, I was hoping someone might be able to shed some light on this subject.
The above lines of code made available via an asp.net web form locked down
using windows auth and inpersonate=true set in web.config does not pass
domain user creds to report server.
I'm assuming problem relates to IIS 6.0 security model and application pool
security identity. Here is my therory.
Page works as expected on a WindowsXP development machine running IIS v5.1
and ASP.NET worker process security. When page is copied to IIS v6.0 web
server page no longer works? the only thing that has changed is the version
of IIS ? Your thoughts please? and any suggestions as to how this may be
overcome would be appreciated.
Thanks in advance for your assistance.
-BenHi Ben,
From your descriptions, I understood that it works fine with IIS 5 while
you encounter credentials issue. If I have misunderstood your concern,
please feel free to point it out.
First of all, please reconfirm the configuration of IIS 6 is the same as
IIS 5. It seems you should be using IIS 6 with Windows Server 2003? If so,
please make sure nothing was blocked.
Secondly, please package your Reporting Services log files in a zipped file
send to v-mingqc@.online.microsoft.com (please note that 'online' is only
for SPAM)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

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.

sql

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

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

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

Reporting service virtual directories on non default web

Hi, I installed the two virtual directories on a new, non default web with
the RS Configuration Tool, what was well done and described on
http://msdn2.microsoft.com/en-us/library/ms155921.aspx. If now I try to
access the server by: http://<hostheader>/reportserver it looks up for a
web.config file
(C:\Programme\Microsoft SQL Server\MSSQL.3\Reporting Services\web.config) in
the base directory. So this file is not there, why it shoud be. With
http://localhost/reportserver it works without this file. What must be done
more to use the report service on non default web?
Thanks, JanCheck the value of the <URLRoot> tag in the rsreportserver.config file.
"JanM" wrote:
> Hi, I installed the two virtual directories on a new, non default web with
> the RS Configuration Tool, what was well done and described on
> http://msdn2.microsoft.com/en-us/library/ms155921.aspx. If now I try to
> access the server by: http://<hostheader>/reportserver it looks up for a
> web.config file
> (C:\Programme\Microsoft SQL Server\MSSQL.3\Reporting Services\web.config) in
> the base directory. So this file is not there, why it shoud be. With
> http://localhost/reportserver it works without this file. What must be done
> more to use the report service on non default web?
> Thanks, Jan
>

Friday, March 9, 2012

Reporting Service on NLB and Virtual Servers

Trying to get reporting Services to work under a Virtual Server that is NLB.
I can access the reports manager and Reports via the Default Web and basic
reports via the virtual server. The problem I cannot access the reports if it
requires a param specified by the user. It fails with a browser DNS error.
Does any know how to make this work. Like I said prior non-param, reports are
working fine. The error only happens with Param reports.
IE: Http://<Virtual IP>/ReportServer?/<Reports Folder>/<Report
Folder>/<report Name>
Another weird thing is this works in our test environment without NLB.Actually after some more investigation I've figured out what was causing the
below mention problem but now something else is weird.
Okay so here is the weird thing. I have created the VDirectories under my
site since we do not use the Default Web Site like most people. Anyway, The
problem I'm having is if I view the VDir on the site Http://<Ip
address>/reportserver I get a cannot connect error "cannot find server
....". The weird thing is if I change the ip address to All Unassigned for
the Site it works fine. Of course this is not acceptable either.
I haven't been able to find anything in regards to what might be causing
this.. Does anyone have a idea?
"James" wrote:
> Trying to get reporting Services to work under a Virtual Server that is NLB.
> I can access the reports manager and Reports via the Default Web and basic
> reports via the virtual server. The problem I cannot access the reports if it
> requires a param specified by the user. It fails with a browser DNS error.
> Does any know how to make this work. Like I said prior non-param, reports are
> working fine. The error only happens with Param reports.
> IE: Http://<Virtual IP>/ReportServer?/<Reports Folder>/<Report
> Folder>/<report Name>
> Another weird thing is this works in our test environment without NLB.

Wednesday, March 7, 2012

Reporting Service 2000 Rendering Extension. Changing Default Opti

Hi Everyone,
I'm having an issue with the CSV export in Reporting Services. The default
encoding for CSV doesn't work the best in Excel. I would like to change the
default encoding type for CSV to ASCII. It this possible?
Thanks
ChadYes it is. You need to alter the RSReportServer.config file for the CSV
rendering extension.
By default, the CSV export is in unicode, to export as ASCII then you'll
need to add some deviceinfo for the CSV rendering as follows :
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
Hope this is what you were looking for.
Phil
"Chad" wrote:
> Hi Everyone,
> I'm having an issue with the CSV export in Reporting Services. The default
> encoding for CSV doesn't work the best in Excel. I would like to change the
> default encoding type for CSV to ASCII. It this possible?
> Thanks
> Chad

Saturday, February 25, 2012

Reporting parameters alignment

Hello All,
First time post question here :)
Is it possible to have 3 or more parameters in one row in RS2000 ? by
default only 2 are alowed to display in one row in reporting parameters
header, and it seems no setting in VS.net 2003 can handle it. or is it
possbile to directly write some xml code to achieve it?
Anyone can help me out ?
Thanks!
Regards,
--ChrisNo, It is handled by SSRS only. if you want to be shown as per your
requirement then you need to create your own forms using asp.net
Amarnath
"neogump" wrote:
> Hello All,
> First time post question here :)
> Is it possible to have 3 or more parameters in one row in RS2000 ? by
> default only 2 are alowed to display in one row in reporting parameters
> header, and it seems no setting in VS.net 2003 can handle it. or is it
> possbile to directly write some xml code to achieve it?
> Anyone can help me out ?
> Thanks!
> Regards,
> --Chris
>|||Amarnath,
Thanks for your information!|||So we cannot customize the report parameter area with our own controls added
to it or changing aligment ? and we cannot add a button on the report
parameter area.
Thanks,
Ravi Manda
"neogump" wrote:
> Amarnath,
> Thanks for your information!
>|||Correct.
"Ravi Manda" <RaviManda@.discussions.microsoft.com> wrote in message
news:32A91524-5F6A-4295-B3B7-E47155E451E1@.microsoft.com...
> So we cannot customize the report parameter area with our own controls
> added
> to it or changing aligment ? and we cannot add a button on the report
> parameter area.
> Thanks,
> Ravi Manda
>
> "neogump" wrote:
>> Amarnath,
>> Thanks for your information!
>>

Monday, March 26, 2012

Reporting Services 2005 : The report server cannot open a connection to the report server databa

Reporting Services Error

Reporting Services 2005 : The report server cannot open a connection to the report server databa

Reporting Services Error

Wednesday, March 21, 2012

Reporting Services - Web Service URL

Reporting Services - Web Service URL

Reporting Services - Web Service URL

Reporting Services - Web Service URL

Reporting Services - Web Service Credentials

Reporting Services - Port Number

Tuesday, March 20, 2012

Reporting Services

Reporting Services

Monday, March 12, 2012

Reporting Services

Reporting service virtual directories on non default web

Friday, March 9, 2012

Reporting Service on NLB and Virtual Servers

Wednesday, March 7, 2012

Reporting Service 2000 Rendering Extension. Changing Default Opti

Saturday, February 25, 2012

Reporting parameters alignment

Reporting in SQL Server

Blog Archive

About Me