Reporting Services Add In

I am attempting to set up SharePoint and Reporting Services to run in
Integrated mode. I have successfully in stalled MOSS 2007 and Reporting
Services. I've installed SP2 for SQL Server and configured Reporting Services
to run in Integrated mode.
For some reason I cannot get the Reportnig Services add on for Sharepoint to
install. It gets to the very end of the installation and then performs a
rollback. I'm logged on as an Administrator. My user is also a farm
administrator. All the prereq's are installed.
The ONLY error I find in Even Viewer is the generic 11708 "failed to
install" error.
Has anyone else encountered this? If so, how did you resolve the issue?
Thanks!Check the log file at:
C:\Documents and Settings\[username]]\Local Settings\Temp\RS_SP_0.log
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:2F9CDC1A-35C4-47D6-A81B-40594AA9A9F6@.microsoft.com...
>I am attempting to set up SharePoint and Reporting Services to run in
> Integrated mode. I have successfully in stalled MOSS 2007 and Reporting
> Services. I've installed SP2 for SQL Server and configured Reporting
> Services
> to run in Integrated mode.
> For some reason I cannot get the Reportnig Services add on for Sharepoint
> to
> install. It gets to the very end of the installation and then performs a
> rollback. I'm logged on as an Administrator. My user is also a farm
> administrator. All the prereq's are installed.
> The ONLY error I find in Even Viewer is the generic 11708 "failed to
> install" error.
> Has anyone else encountered this? If so, how did you resolve the issue?
> Thanks!
>

reporting services 2005 proxy

I am trying to create a RS proxy to use in my web site. I did this successfully with RS2000. I used web matrix to generate the proxy and put the dll and .cs file in the bin directory of the web site, then I just used <%@. import namspace="rsProxy" %>. It worked like a charm. Now I am trying to get the 2005 version working and created the dll's but all I get in my web page is that it couldn't find the namespace.

I also tried adding a web reference through VS 2005. I don't use projects in my web site so in the VS 2005 method it created a folder under my web site called App_WebReferences. In that folder was another named after my server (reference name defaulted it to, say myServerName). Within that folder there are two files: reportservice2005.discomap and reportservice2005.wsdl. I then tried thier examples to create an instance of ReportingService2005 on the page_load event:

reportservice2005.myServerName.reportservice2005 rs = new reportservice2005.myServerName.reportservice2005();

rs.Url = "http://myservername.reportserver/reportservice2005.asmx?wsdl";

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

I get the follwiong error:

CS0246: The type or namespace name 'reportservice2005' could not be found (are you missing a using directive or an assembly reference?)

I tried to import the namespace as I did in 2000 with the same error.

I am trying to read the listchildren and populate a treeview. Any suggestions?

Not sure how VS 2005 is different in this respect, but in any case you could use wsdl.exe to extract a *.cs file from a SOAP endpoint. Then you can just include that file in your project.|||

I can get the dll and .cs file to generate. Again, I am not using projects in my web site. Even when I created the web reference in VS it showed all the methods available in the reportingservice2005 and reportexecution2005. I generated it and have tried to implement it using multiple methods but none work. Is there something on the report server or IIS that needs to be setup in order to make a web service available for consumption? I was thinking that maybe during the installation or configuration I missed something. Anyway, I followed the exact same process I used with RS 2000 and it doesn't work.

By the way, thanks for the reply. I'll keep plugging away at it.

|||

ok, I got it this far. I can get the auto-list members to display in VS 2005. Here is my code:

WindowsImpersonationContext impersonationContext;

WindowsIdentity currentWindowsIdentity;

currentWindowsIdentity = WindowsIdentity.GetCurrent();

impersonationContext = currentWindowsIdentity.Impersonate();

rsWebReference.ReportingService2005 rs = new rsWebReference.ReportingService2005();

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

rsWebReference.CatalogItem[] items = rs.ListChildren("/", true);

foreach (rsWebReference.CatalogItem ci in items)

{

if (ci.Type.ToString() == "Folder" && ci.Hidden == false)

{

Response.Write(ci.Name);

Response.Write(ci.Path);

}

}

impersonationContext.Undo();

Even though the list members are working, it still gives me the same error:

The type or namespace name 'rsWebReference' could not be found (are you missing a using directive or an assembly reference?)

|||The problem was the web site is using the 1.1 framework. When I changed it to use 2.0 it worked.

Reporting Services 2005 on Windows 2000 server

Hi,

I successfully got SQL 2005 Express with reporting services running under VISTA. Developed some reports in the VISTA environment. However, my target system is a Windows 2000 server. We installed SQL 2005 w/reporting services onto the Windows 2000 server. SQL2005 Database is up and running. Reporting Services are running, IIS RRS virtual directories are built, RRS databases are built. I can do everything except deploy reports from Business Intelligent Studio. I can preview reports, just cannot deploy. The Reporting Services indicate 1 failure in its configuration; the Web Service Identity. It is loaded with <server>\ASPNET. I cannot get rid of this error. I assume this is the problem. After digging around I found that Windows 2000 does not have an ASPNET user, it uses the IWAM user instead. Reporting services did not run at all till I changed the rs config file and put the IWAM user in as <WebServiceAccount>.

Does anyone have Reporting services 2005 running on Windows 2000 server? Anyone know how to fix the Web Service Identity error I am getting?

Thanks

Could you please post the whole error message ?|||

I have the same problem too...

I can't change the value of ASP .NET Service Account in the text box and when I try to apply what is proposed (MACHINENAME\ASPNET - that don't exists), I receive the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

I hope in a solution ....

|||

Hi Matteo and rodgerst,

Could you, please, connect to your Report Server instance using the config tool, choose Report Server and Report Manager virtual directories tabs, check Apply Default Settings, and then press Apply?

If the previous workaround was not working, could you, please, go to this registry key corresponding to the RS instance:

HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.x\Setup

and look for this key: ReportManagerIdentityConfigured. Please change its value to what you want to have for your web service identity (the IWAM user).

I hope it helps. Please let me know how this is working for you.

Mihaela

|||

Hi Mihaela

I've tried the first workaround, close and open RS Config Manager but ....nothing: a red X on web service identity and a locked textbox with the same wrong value.

The value specified in the second workaround don't exists in the registry key, and in entire registry... I've tried to create it, close and reopen Config Manager but .... nothing ....

If can be useful at this link i've saved a screenshot of registry

http://www.matteodistefano.it/public/registrySS.gif

Thanks in advance

Matteo

|||

Matteo,

I see from your screenshot that you have SQL Express Advanced SP1 installed on the Windows 2000 machine, which is your Reporting Services server. I would suggest to try to install SP2 and see if this is working.

Thank you,

Mihaela

|||

Hi Mihaela

Thanks for your answer,

For the moment I can't access directly to it, so I won't risk to install a service pack remotely on a production server.

I'll do it after 6 weeks.

Any other suggestions are appreciate.

Thanks

|||

Tried applying default settings; did not help. Tried regedit; ReportManagerIdentityConfigured is not a key in either MSSQL.1 or MSSQL.2. Should I try adding it to MSSQL.2\Setup?

|||My registry looks like Matteo's snapshot except we are running the Enterprise Evaluation Edition.

Reporting Services 2005 on Windows 2000 server

Hi,

I successfully got SQL 2005 Express with reporting services running under VISTA. Developed some reports in the VISTA environment. However, my target system is a Windows 2000 server. We installed SQL 2005 w/reporting services onto the Windows 2000 server. SQL2005 Database is up and running. Reporting Services are running, IIS RRS virtual directories are built, RRS databases are built. I can do everything except deploy reports from Business Intelligent Studio. I can preview reports, just cannot deploy. The Reporting Services indicate 1 failure in its configuration; the Web Service Identity. It is loaded with <server>\ASPNET. I cannot get rid of this error. I assume this is the problem. After digging around I found that Windows 2000 does not have an ASPNET user, it uses the IWAM user instead. Reporting services did not run at all till I changed the rs config file and put the IWAM user in as <WebServiceAccount>.

Does anyone have Reporting services 2005 running on Windows 2000 server? Anyone know how to fix the Web Service Identity error I am getting?

Thanks

Could you please post the whole error message ?|||

I have the same problem too...

I can't change the value of ASP .NET Service Account in the text box and when I try to apply what is proposed (MACHINENAME\ASPNET - that don't exists), I receive the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

I hope in a solution ....

|||

Hi Matteo and rodgerst,

Could you, please, connect to your Report Server instance using the config tool, choose Report Server and Report Manager virtual directories tabs, check Apply Default Settings, and then press Apply?

If the previous workaround was not working, could you, please, go to this registry key corresponding to the RS instance:

HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.x\Setup

and look for this key: ReportManagerIdentityConfigured. Please change its value to what you want to have for your web service identity (the IWAM user).

I hope it helps. Please let me know how this is working for you.

Mihaela

|||

Hi Mihaela

I've tried the first workaround, close and open RS Config Manager but ....nothing: a red X on web service identity and a locked textbox with the same wrong value.

The value specified in the second workaround don't exists in the registry key, and in entire registry... I've tried to create it, close and reopen Config Manager but .... nothing ....

If can be useful at this link i've saved a screenshot of registry

http://www.matteodistefano.it/public/registrySS.gif

Thanks in advance

Matteo

|||

Matteo,

I see from your screenshot that you have SQL Express Advanced SP1 installed on the Windows 2000 machine, which is your Reporting Services server. I would suggest to try to install SP2 and see if this is working.

Thank you,

Mihaela

|||

Hi Mihaela

Thanks for your answer,

For the moment I can't access directly to it, so I won't risk to install a service pack remotely on a production server.

I'll do it after 6 weeks.

Any other suggestions are appreciate.

Thanks

|||

Tried applying default settings; did not help. Tried regedit; ReportManagerIdentityConfigured is not a key in either MSSQL.1 or MSSQL.2. Should I try adding it to MSSQL.2\Setup?

|||My registry looks like Matteo's snapshot except we are running the Enterprise Evaluation Edition.sql

Reporting Services 2005 and jump-to report navigation

Hi, I have used Jump-To report navigation in RS 2000 successfully to
navigate from one report to another, passing a report parameter to the
second report from a click event from a table in the parent report.
However, when I try to do the same thing in RS 2005, when I set up the
navigation jump-to report, the form picks up the report I want to
jump-to, but not any of the report parameters.
Has anyone found this problem and has anyone solved it?
I am using the April CTP install of Business Intelligence Studio
(Client Tools) connecting to an April CTP of Yukon on another server.
Thanks for any helpI believe we saw this issue and fixed it in the upcoming CTP15(June). I
tried a simple JumpTo report with CTP15 using a parameter and it works fine.
--
| From: "MDXQuery" <imgroup1@.hotmail.com>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Reporting Services 2005 and jump-to report navigation
| Date: 31 May 2005 07:31:18 -0700
| Organization: http://groups.google.com
| Lines: 13
| Message-ID: <1117549878.146860.257860@.o13g2000cwo.googlegroups.com>
| NNTP-Posting-Host: 212.135.29.68
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1117549883 20456 127.0.0.1 (31 May 2005
14:31:23 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Tue, 31 May 2005 14:31:23 +0000 (UTC)
| User-Agent: G2/0.2
| Complaints-To: groups-abuse@.google.com
| Injection-Info: o13g2000cwo.googlegroups.com; posting-host=212.135.29.68;
| posting-account=BkKmtgwAAAA2HVQbpzZ1Z_YN45g-L9kZ
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o1
3g2000cwo.googlegroups.com!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45004
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi, I have used Jump-To report navigation in RS 2000 successfully to
| navigate from one report to another, passing a report parameter to the
| second report from a click event from a table in the parent report.
| However, when I try to do the same thing in RS 2005, when I set up the
| navigation jump-to report, the form picks up the report I want to
| jump-to, but not any of the report parameters.
| Has anyone found this problem and has anyone solved it?
|
| I am using the April CTP install of Business Intelligence Studio
| (Client Tools) connecting to an April CTP of Yukon on another server.
|
| Thanks for any help
|
|sql

Reporting Services 2005 - Security Extention

Hi,

I have compiled the security extension sample code that comes with the installation and I was able to successfully deploy it on the Reporting Server. Now my server asks me for username, password when browse to the http://servername/reports folder. I have configured one user as say "AdminUser".

When I login as AdminUser, I am to see all my reports and browse thru them.

I created one more user say "RegUser". I have logged in as AdminUser and I have give permissions to RegUser for some folders on report server.

Until this point every thing just worked fine and absolutly no problems.

The real problem shows up when the "RegUser" logs in to the system. He is able to login, but he cannot see any thing on the Home Page. Even though I have give permission to this RegUser, he is not able to see his folders.

If any body has solved this problem before or had any idea whats going on... please throw me an idea.

Thanks in advance.

Giri

What permission did you give him ? make sure that he is on the group of systeusers in Reporting Services, otherwise he won′t be able to see anything on the report server.

HTH, Jens Suessmeyer.

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

I have given him the role "Browser" to a particular folder, but that is not helping me out.

Are you talking about giving setup in of the config files?

|||It sounds like issues with Authorization. make sure you have the function checkOperations properly overloaded and that your GetPermissions function is gathering the roles properly. It could also be that the roles defined in the Report Manager are not syncing up with the roles defined in your application/database.

Reporting Services 2000 SP2 fails

I have installed SP2 successfully a number of times before, but always where the Report Server and the Report Server databases were on the same box. This is the first time trying to install the Service Pack where the Report Server is on server X and the databases are on server Y.

When I try to run the SP (on server X), I get the following message:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I am logged in using a domain account that is a local admin on both servers (and also the SQL Server startup account on server Y). It is also the account used by the Report Server to connect to the RS databases. The startup account for the Report Server service is 'NT AUTHORITY\NETWORK SERVICE'.

Hi,

Try to change the SSRS service account to a domain account, and add this account to your SSRS database server and map to your SSRS database. Also, you should add this account to the RsExecRole role.

I hope it helps.

Regards,

Janos

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