Reporting Services

Dear All,

Developed a report using Reporting services (2005)integrating Chart FX .The report is built successfully but raises an error on deployment.

Error: Could not connect to the report server.

To resolve the error in the properties of the project i had given the target server url=Http://localhost/webfoldername (installed webservices on the local server)

but still i am getting the same error.

How to resolve the error.

Regards

Mohd Sufian

Hi,

didi you figure out if the WebService is currently running ? Just navigate to http://machinename/Reportserver (or whatever you directory for webservices is) to see if something is displayed there.

-Jens Suessmeyer.

http://www.sqlserver2005.de/|||

Dear ,

I had installed web services in a stand alone machine.

The location of the web services is http://localhost/webfoldername

but is still not working.

Regards

Mohd Sufian

|||

Dear,

the Reporting Server do not deploy on the <local host> i mean to say not by servername not giving local host.

we have to give the webserver name like this

http://asd.com/foldername

Hope u get what i try to explain

Regards

sufian

|||OK, which error are you getting suring the deployement, can′t the server be found or what error occurs ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Dear ,

First i got the error Target server Url cannot be accessed(invalid source).Then i provided the webserver address.It worked fine.

For deployement of the report i connected to Reporting Services in Management Studio.

There i got number of errors which i resolved by studying the help.

Error Example:

w3wp!runningjobs!1!6/23/2006-20:52:59:: 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.RPCException: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: 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. Check the documentation for more information. (rsReportServerDisabled) > System.Exception: Bad Data. (Exception from HRESULT: 0x80090005)

|||

Sounds like you need to configure your report server. Use the Reporting Services Configuration Tool for that purpose.

-Lukasz

|||

Thats probably like the error message is telling you. YOu have to either restore the symetric key which is used to encrypt and decrypt the report definition in the Report Server Database or if you don′t have a backup copy, delete all encrypted content in the database. AFAIK there is no way to rescue the data if the key is lost. Like Lukasz said, you can do all the administrative stuff in the Reporting Services Configuration tool. If you don′t have a valid backup of your symetric key, do this as a first step after deleting all the encrypted content.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||

Dear Jens,

Sorry not to post before as i had solved the problem long time back.

The problem doesnt occure because of Encryption keys.

The problem occured becuase the shared Datasource used in building the report is

is blocked by some source.so i created again the datasource after i connect to the reporting services from management studio.

HTH

from

sufian

|||

mohd sufian,

I am having the exact same error (the symmetric keys complaint.)

Could you post in exact details what you did to fix the problem?

Thanks,

AIMDBA

|||

Dear AIMDBA,

First go to the properties of the project.

Provide the URLSource as HTTP://Computername having the webservices installed/webfolder/

Run the report .

Now connect to the Management studion and connect to SSIS.

Import the report u developed right click and run .U will see the error.

Go to the properties and create a new datasource same as the datasource provided in the report.

Now execuete the report.

If u still can accesse the report.Browse to the Reporting services configuration

Check weather all things configured properly.

If still not working delete the encription keys and save again.Backup the encription keys.

Windows Service Identity (Service Account ) should be NT AUTHORITY\Network Service

Web Service Identity (ASP.NET Service ) NT AUTHORITY\NETWORK Services

HTH

from

sufian