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

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

reporting licensing

We recently purchased Stockamp's Clinic Ontrac system. The system has a built in crystal reports viewer module with capability to add our own reports... The backend of the product is SQL Server. To create a report you have to potentially create a stored procedure - if parameter is needed - and a crystal report. Stockamp is requesting that we have written approval of these reports as well as any ad-hoc reports and queries that we run before we run them in the production environment.

I'm used to large vendors (those that understand a database is only as good as the data you get out of it) and I've never seen a license agreement like this before. Is this common?What they are trying to do is to ensure that by creating a report you're not going to impact the production environment in such a way that they may be blamed for poor performance while your report is being generated. Also, since they introduced a "report writer," this means that there are not many "canned" reports in the system that they sold you, and they are trying to piggy-bag on your reports and incorporate them in the next release as "canned" reports.|||If possible, you should consider replicating your data on a dedicated report server. This will avoid potential performance issues.|||Unfortunately the data changes constantly, and I suspect if they won't let me add reports, they won't let me replicate. It took me over 2 months to convince them we needed a seperate test server as making a modification to their system (using their own forms and an approved process) required a 4 hour import that completely paralized the system.
The database tables have grown from 2000 rows 9 months ago to over 21 million, so reporting out of the system will soon become too cpu intensive anyway.
I'd love to work with the vendor and introduce them to datawarehouseing, but they're product is so fragile and Stockamp & Associates employees are so unwilling to listen, that I given up on a friendly working relationship.
So the moral is to avoid software with a canned report viewer, regardless of its backend system.