reporting services url fail-HELP

Search: Find

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles

Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
Creating an SSL Certificate to ensure your confidential reports remain confidential

SQL Reporting Services - Answers to your questions

Notify me of new comments

Author

Thread: reporting services url fail-HELP

sivan

reporting services url fail-HELP
Posted: Monday, March 29, 2010 9:17 AM (GST)

Hi,

I'm trying to connect to the reporting services url.

when I connect to it I get the following error:

"The report server cannot open a connection to the report server database...Exception from HRRESULT: 0x8007052E".

Something that has to do with the credentials I think.

Not sure what to do here.

I'd appreciate any relevant info.

Thanks

Comments:

Author Thread:

William Vaughn

reporting services url fail-HELP
Posted: Monday, March 29, 2010 5:49 PM (GST)

It would help to know how you're trying to connect.

I suggest using the Reporting Service Configuration manager and click on the Report Manager or Web Service URL links.

If that fails, use SQL Server Configuration manager to ensure that the Reporting Service instance is started.

Next, if you can connect via the RSC inspect your data source with Report Manager and inspect the Data Source in question. If you're using Integrated Security make sure the (your) account has a Login on the server and you have rights to the initial catalog.

If the server is remote (on another system than the database) make sure the SQL Browser service is running and that the firewall is not blocking the ports.

hth

sivan

reporting services url fail-HELP
Posted: Monday, March 29, 2010 11:50 PM (GST)

1. I used the Reporting Service Configuration manager and clicked on the Report Manager Web Service URL link.

when I pressed that link that raised the explorer with the failure message.

2. In the SQL Server Configuration manager the "SQL server reporting services" is running but thr services: Sql server agent and sql server browser can' be activated-does that have anything to do with it?

3. what do you mean by "connect via the RSC ".

4. I noticed something weird, when I configure the database connection through Reporting Service Configuration manager it seems that I get a default password and I didn't assign it!

any ideas for me?:) I can send you screen shots for better understanding.

thanks again..

William Vaughn

reporting services url fail-HELP
Posted: Tuesday, March 30, 2010 6:42 PM (GST)

Okay, what account are you using for the service and execution accounts? These should be domain accounts with sufficient rights to access the RS catalog. "RSC" = Reporting Services Configuration manager. I would reset the login credentials for the database connection.