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

Reporting Services + Vista Home Premium = @!!$#%*

I am just wondering....

Has ANYONE actually gotten Reporting Services to install under Windows Vista Home Premium?!?!

I have gone through every possible fix, KB Article and anecdote and I STILL can't get it to install. Every IIS option is there that should be there.

In all honesty, what was Microsoft thinking? I'll make RS compatible with every OS we offer EXCEPT this one...

What truly bites is now that Visat is out, it is almost impossible to buy a new laptop/PC without it. Looks like it's nuke my new laptop and install XP...great...

What edition of SQL 2005 do you have? Enterprise, Standard and Workgroup edition are not supported on

Windows Vista Home Premium Edition.

If you have a version other than those, what error messages are you getting?

|||

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

|||

ansonee wrote:

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

No, not on Vista Home Premium Edition. See this link: http://technet.microsoft.com/en-us/library/ms143506.aspx

|||Under SQL Server Business Intelligence Development Studio you will be able to develop reports. IIS must be installed with a specific set of features enabled. Home does not support one of the required authentication features. I am in the same boat. I too am not happy with Vista and Microsoft. We need the non-home edition of Vista.|||

A little clarification on my account ...

Reporting Service; the service side of it, requires hosting via IIS. One can run the RDL's in preview mode in the VS designer. A limited option is to use the 'local' (versus server) option in the report viewer controls.

The service part of Reporting Service in the 2008 release will be able to be hosted in something other than IIS. I would assume because it has been redone using WCF. What the hosting options are I do not know. So, one solution for both of us might be installing 2008 beta version.

|||

Hey there!

Nope, Reporting Services will not install /run in Home versions of Vista. You'll need

the business version or some other higher end version of it. In other words..more

$$$, that in MHO is MS's thinking. I wish you luck, you're on the right track with an XP

install.

Best,

>Scott

Reporting Services + Vista Home Premium = @!!$#%*

I am just wondering....

Has ANYONE actually gotten Reporting Services to install under Windows Vista Home Premium?!?!

I have gone through every possible fix, KB Article and anecdote and I STILL can't get it to install. Every IIS option is there that should be there.

In all honesty, what was Microsoft thinking? I'll make RS compatible with every OS we offer EXCEPT this one...

What truly bites is now that Visat is out, it is almost impossible to buy a new laptop/PC without it. Looks like it's nuke my new laptop and install XP...great...

What edition of SQL 2005 do you have? Enterprise, Standard and Workgroup edition are not supported on

Windows Vista Home Premium Edition.

If you have a version other than those, what error messages are you getting?

|||

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

|||

ansonee wrote:

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

No, not on Vista Home Premium Edition. See this link: http://technet.microsoft.com/en-us/library/ms143506.aspx

|||Under SQL Server Business Intelligence Development Studio you will be able to develop reports. IIS must be installed with a specific set of features enabled. Home does not support one of the required authentication features. I am in the same boat. I too am not happy with Vista and Microsoft. We need the non-home edition of Vista.|||

A little clarification on my account ...

Reporting Service; the service side of it, requires hosting via IIS. One can run the RDL's in preview mode in the VS designer. A limited option is to use the 'local' (versus server) option in the report viewer controls.

The service part of Reporting Service in the 2008 release will be able to be hosted in something other than IIS. I would assume because it has been redone using WCF. What the hosting options are I do not know. So, one solution for both of us might be installing 2008 beta version.

|||

Hey there!

Nope, Reporting Services will not install /run in Home versions of Vista. You'll need

the business version or some other higher end version of it. In other words..more

$$$, that in MHO is MS's thinking. I wish you luck, you're on the right track with an XP

install.

Best,

>Scott

Reporting Services + Vista Home Premium = @!!$#%*

I am just wondering....

Has ANYONE actually gotten Reporting Services to install under Windows Vista Home Premium?!?!

I have gone through every possible fix, KB Article and anecdote and I STILL can't get it to install. Every IIS option is there that should be there.

In all honesty, what was Microsoft thinking? I'll make RS compatible with every OS we offer EXCEPT this one...

What truly bites is now that Visat is out, it is almost impossible to buy a new laptop/PC without it. Looks like it's nuke my new laptop and install XP...great...

What edition of SQL 2005 do you have? Enterprise, Standard and Workgroup edition are not supported on

Windows Vista Home Premium Edition.

If you have a version other than those, what error messages are you getting?

|||

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

|||

ansonee wrote:

I'm using Enterprise Edition...I was able to install every component of SQL Server 2005 except for Reporting Services...

Is there ANY way to get it installed?

No, not on Vista Home Premium Edition. See this link: http://technet.microsoft.com/en-us/library/ms143506.aspx

|||Under SQL Server Business Intelligence Development Studio you will be able to develop reports. IIS must be installed with a specific set of features enabled. Home does not support one of the required authentication features. I am in the same boat. I too am not happy with Vista and Microsoft. We need the non-home edition of Vista.|||

A little clarification on my account ...

Reporting Service; the service side of it, requires hosting via IIS. One can run the RDL's in preview mode in the VS designer. A limited option is to use the 'local' (versus server) option in the report viewer controls.

The service part of Reporting Service in the 2008 release will be able to be hosted in something other than IIS. I would assume because it has been redone using WCF. What the hosting options are I do not know. So, one solution for both of us might be installing 2008 beta version.

|||

Hey there!

Nope, Reporting Services will not install /run in Home versions of Vista. You'll need

the business version or some other higher end version of it. In other words..more

$$$, that in MHO is MS's thinking. I wish you luck, you're on the right track with an XP

install.

Best,

>Scott

Reporting Service Login dialog when trying to deploy a report

I am using SQGExpress, and can open the home page at
http://localhost/reports, but after previewing a report, when I try to deploy
the report I get a dialog asking for for a user name and password.
1. why do i get this dialog, and
2, what is it expecting; I have tried all that I could think of, but have
found to reponse that is accepted
Thanks
--
TomGHave you allowed Anonymous Access to the Report Server web application? Then
RS won't know which user you are trying to be, and probably bans any
deployment.
Kaisa M. Lindahl Lervik
"TomG" <TomG@.discussions.microsoft.com> wrote in message
news:7FC9358C-9678-45E6-8957-048A1E2F52F9@.microsoft.com...
>I am using SQGExpress, and can open the home page at
> http://localhost/reports, but after previewing a report, when I try to
> deploy
> the report I get a dialog asking for for a user name and password.
> 1. why do i get this dialog, and
> 2, what is it expecting; I have tried all that I could think of, but have
> found to reponse that is accepted
> Thanks
> --
> TomG|||thanks for your response.
I do not know. I will have to find how to determine and/or change if need be.
will do some digging and repost
--
TomG
"Kaisa M. Lindahl Lervik" wrote:
> Have you allowed Anonymous Access to the Report Server web application? Then
> RS won't know which user you are trying to be, and probably bans any
> deployment.
> Kaisa M. Lindahl Lervik
>
> "TomG" <TomG@.discussions.microsoft.com> wrote in message
> news:7FC9358C-9678-45E6-8957-048A1E2F52F9@.microsoft.com...
> >I am using SQGExpress, and can open the home page at
> > http://localhost/reports, but after previewing a report, when I try to
> > deploy
> > the report I get a dialog asking for for a user name and password.
> >
> > 1. why do i get this dialog, and
> > 2, what is it expecting; I have tried all that I could think of, but have
> > found to reponse that is accepted
> >
> > Thanks
> > --
> > TomG
>

reporting service error

When I try to run the web page which host the report, I am not able to reach the home page and following error show up.

" The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data."

I then went to Reporting Services Configuration Manager -> Encryption Keys

then I clicked the Change button

after all these I can get back to the reporting service home page. Any one can tell me the reason of this error? thanks

when I tried to open the reporting service web site. The following error pop up

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

Then I go to Reporting Service Manager-> Encryption keys. After I changed the encryption keys; the reporting service works again. Could anyone explain the reason behind this? ans is that the right way to reslove the error?

Thanks

|||Reporting Services data is encrypted. Did you restore the database or change the service account not through the Condifguration manager ? After changing / deleting the key 8and the encrypted content) the database was empty, you had a new key and you could start all over.

Jens K. Suessmeyer.

http://www.sqlserver2005.de