InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 11:37:36 GMT20http://www.sqlservercentral.com/Forums/Topic1305685-150-1.aspxHi, Can anyone help me with the following?We are implementing a BI solution where I work and have proposed to have the SSRS service running on its own dedicated server. We are looking at implementing SSRS 2012, the current SSRS solution is running in SSRS 2005 and supports 300 - 400 users daily. I was wondering if anyone has any experience in specifying the hardware requirements of a stand alone SSRS box to support this volume of users. In terms of memory, hard disk spec and config, networking, are there a set of baselines to follow or any recommendations. If any one can point me to any useful links on this matter it would be greatly appreciated, all I could find where the minimum specs on the MicroSoft siteMany ThanksThu, 24 May 2012 04:42:56 GMTthomasbrennan10http://www.sqlservercentral.com/Forums/Topic1305492-150-1.aspxHi Friends,I installed reporting services in our environment. Configured the Sharepoint Integrated Mode. Now I am asked to revert it to back to Native mode due to some other requirement. I could not find an option to drop or overwrite.Please help.REgardsGovindWed, 23 May 2012 21:30:59 GMTgovindarajan69http://www.sqlservercentral.com/Forums/Topic1303500-150-1.aspxI currently have a WPF application that had been in production 2 years. Our technical team would like to replace the Telerik chart and graph controls with SSRS. The graphs that they produced for me with SSRS were significantly inferior to the Telerik controls and they were unable to insert data into the SSRS header and footer like we do in Telerik. Our customers love the preset Telerik charts and I am concerned that I will be going from very cool back to a basic chart. Please advise.Mon, 21 May 2012 10:15:19 GMTktaylor 22285http://www.sqlservercentral.com/Forums/Topic1302219-150-1.aspxI have created a custom login page so our users can logon to Reporting Services using their username and password that are stored in our internal database. The problem I'm having is when they login from the custom login page it prompts for another username and password for the server that is running Reporting Services. How can I disable this from prompting this second login screen? Is that possible?Thu, 17 May 2012 18:28:24 GMTmldardyhttp://www.sqlservercentral.com/Forums/Topic1304420-150-1.aspxI have a SSRS 2008 report with a bubble chart in the group header. The values for the bubble chart axis are 0-2 on the X axis, and 0-2 on the y axis. I may have data that falls out of the range of the bubble chart, and we show these records in the detail bands of the report. Via the visible property, we only show the records that fall out of the range of the bubble chart axis...say 3+. We'd like to take the detail bands and have 2 columns instead of just 1...as that would save paging for the report.So, instead of:record1record 2record 3record 4...we'd like:record 1 record 2record 3 record 4 I have looked at the newspaper style, but that won't work for us b/c of the bubble chart...we only want the "3+" detail band data to split to 2 columns. Any ideas? I thought you could do this with a matrix control, but I'm not locating anything with Google searches. Thanks!Tue, 22 May 2012 12:44:10 GMTSol_Web_Solutionshttp://www.sqlservercentral.com/Forums/Topic965324-150-1.aspxAlthough you can make a folder invisible in the view list, if you click on show details, the folder shows up and the user has access to it. This ocurrs even if the user has the bare minimum permissions. I need to hide this button so the user cannot go to details view.You may ask, why not just block access to the folder. The answer is that reports located in that folder have to be able to be called by users through other software, using reportviewer. Blocking access from the server also blocks access via the software.In short, I need to hide the show/hide details button on the toolbar.Thank you.Fri, 06 Aug 2010 10:47:02 GMTtsmith-960032http://www.sqlservercentral.com/Forums/Topic1303352-150-1.aspxHi ,Im a newbie to the world of report building and BIDS in particular.I need assistance - I need to illustrate a breakdown in charging time of a battery based on the report start time and report end timeso if the report is drawn from 18:00 to 23:00i need to display in the following manner: charged 19h05-19H15 10 mins 20h40-20h55 15 mins 21h04-21h45 41 mins ect-till 23:00TOTAL charge time = xx mins e.g (which must be converted into HH:MM:SS)How to i do this?Mon, 21 May 2012 06:51:02 GMTjparenzeehttp://www.sqlservercentral.com/Forums/Topic1299732-150-1.aspxI have a chart and a textbox underneath. Below to that, I have another chart and a textbox underneath. The problem is,In preview it is fine, when I export it to pdf, first chart is in first page and the textbox underneath is fine. In the second page, I could see the second chart but the text box underneath the second chart is getting displayed in the first page itself. Is there anyway, I can get the textbox concerned to the second chart to be displayed in the second page underneath the chart?Mon, 14 May 2012 10:57:15 GMTrajendraramahttp://www.sqlservercentral.com/Forums/Topic1301938-150-1.aspxHi,I added a web reference to ReportExecution2005.asmx?WSDL from my ASP.NET MVC application.After I render the report to HTML4, I check the source of the HTML with "view source", andbelow is the information that I see. Is there any way to "tell" SSRS not to include all thisinformation on the HTML? If not, is there any work around?This meta content is giving some information about my internal network, like the Reporting Services server name. It is also giving the parameters' information.Thanks in advance,qdtb<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><title>TESTREPORT</title><META http-equiv="Content-Type" content="text/html; charset=utf-8"/><META http-equiv="Content-Style-Type" content="text/css"/><META http-equiv="Content-Script-Type" content="text/javascript"/><META HTTP-EQUIV="Location" CONTENT="http://server/ReportServer?%2fDaily+Queries%2fTESTREPORT"/><META HTTP-EQUIV="Uri" CONTENT="http://server/ReportServer?%2fDaily+Queries%2fTESTREPORT"/><META HTTP-EQUIV="Last-Modified" CONTENT="05/17/2012 14:14:30"><META NAME="MONTH" CONTENT="4"><META NAME="YEAR" CONTENT="2012"><META NAME="Generator" CONTENT="Microsoft Report 8.0 "/><META NAME="Originator" CONTENT="Microsoft Report 8.0 "/>Thu, 17 May 2012 10:26:57 GMTGustavo Alvarezhttp://www.sqlservercentral.com/Forums/Topic1276975-150-1.aspxI have a random SSRS issue that is causing the reporting services service to use 100% CPU. The issue will not resolve until SSRS is restarted.I have seen this at other times when excessing blocking occurred on the source. But there are no blocking issues or waits on the source database server. I don't see any unusual entries in the reporting services log. The ExecutionLog2 view shows reports still being processed and nothing but rsSuccess on the statuses. This has happened once a week for the past few weeks but not at the same time or on the same day. Any guidance on where to look next would be greatly appreciated!Thanks,KimMon, 02 Apr 2012 15:27:59 GMTktalley.dbahttp://www.sqlservercentral.com/Forums/Topic1300298-150-1.aspxHi everyoneI hope somebody can help. I have the following SWITCH statement in one of my reports:=Switch(sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <-2.5, "Green", sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 <=-5.0, "Yellow", sum(Fields!YTDBudget.Value)/sum(Fields!YTDActual.Value) -1 >-5, "Red")Essentially it calculates the Budget/Actual difference and then RAG rates the result. However, it's not working as it should. I'd like the RAG to be Green when the result is less than -2.5%, Yellow when it's greater then -2.5% but less than -5.0% and finally Red when greater than -5.0%. The current function does not appear to be working and the result is always red (I know that this is not the case). I'm assuming it has something to do with the negative numbers but not sure what exactly...Any help would be really appreciated...BOTue, 15 May 2012 08:34:16 GMTByronOnehttp://www.sqlservercentral.com/Forums/Topic1300934-150-1.aspxOn our SQL 2008 reporting server, there is a problem when you try to create a subscription. It puts your Windows where your email address is supposed to go. It doesn't resolve the email so the subscription fails. Also, the Select All function of the parameters isn't there in the subscription. However, you can see it when you run the report manually.Wed, 16 May 2012 05:52:59 GMTExpress12http://www.sqlservercentral.com/Forums/Topic1299519-150-1.aspxI currently use a domain login to get to reporting services either by logging on as Adminstrator so I can manage up Reporting services and as a reportuser where a person can view reports but not do anything else like an Administrator can. The idea is our sales managers' to log on to Reporting services with their own account. It was mentioned to me by my manager that he wants a login page created for this. That got me to thinking if I do this how would I get on to the page as an administrator to do what I need to do. I would like to know what anyone suggestions are for doing this. I don't really know how I would go about doing this and what kind of problems this may cause. Any suggestions?Mon, 14 May 2012 06:59:15 GMTmldardyhttp://www.sqlservercentral.com/Forums/Topic1293660-150-1.aspxHiNew to SSRS, setting up some basic reports for users. At the moment, the reports are for different departments. For example, an invoices reports for the Account department. Now the Accounts department is an Active Directory group, so it was easy to secure the invoices report. But what should I do in the future? Should I set up new AD groups just for SSRS? Or should I use existing groups where possible?ThanksWed, 02 May 2012 02:14:08 GMTAwesomohttp://www.sqlservercentral.com/Forums/Topic1298927-150-1.aspxI have created a column chart in which the data is showing up properly on the x and y axis but, the actual bars dont show up..any idea what the cause might be?? Thanks in advanceFri, 11 May 2012 13:32:22 GMTrockstar283http://www.sqlservercentral.com/Forums/Topic1299719-150-1.aspxI have a report where I have a few datasets (simply because there is so much data and it's so diverse). I've matched the tables together so that it looks like one grid. Things look fine in BIDS. But when I deploy the report a very small space appears between two of the tables that are matched in BIDS. Has anyone else experienced this?Mon, 14 May 2012 10:45:43 GMTDataAnalyst110http://www.sqlservercentral.com/Forums/Topic1297915-150-1.aspxI get errors when I try to format percentage. I've tried just about everything not sure what I'm missing. I tried it two ways the first by going into the Expression and formatting. This is where it just says 'Error' Here is code:=round(Fields!ContainerDiff2010vs2011Fct.Value/Fields!LastYearQtyActualContainers.Value * 100,2)& "%"The other is when I am using this code and I right click on the textbox, go to Properties and format code and select Percentage and it says 'NaN':=Fields!ContainerDiff2010vs2011Fct.Value/Fields!LastYearQtyActualContainers.ValueWhich one should I use for formatting percentage and what is the correct code to get it to work?Thu, 10 May 2012 08:26:37 GMTmldardyhttp://www.sqlservercentral.com/Forums/Topic1299698-150-1.aspxHello;I have about 20 databases for which I like to run reports, same structure.Dynamic connection string works fine with Parameters!Databes.ValueHowever when I change this Parameter to Allow Multiple Values I'm having an "error during processing of the ConnectString expression of data source".Is that anyway to overcome this error and be able to show records from different dbases grouped by database name?Mon, 14 May 2012 10:18:54 GMTkawiorskihttp://www.sqlservercentral.com/Forums/Topic1299602-150-1.aspxHi All,I have created a System DSN which connects, and tests successfully to an excel workbook. I then set up a new SSRS report in BIDS, and a new Shared Data Source (and corresponding Data Source), which connects successfully to the Excel workbook.I then setup a new dataset, which simply says "SELECT * FROM [StaffStatistics$]", and this, again, when run in the Query Designer of the Dataset Properties, returns all of the required data.However, when I then press "Preview" to return this data to a Tablix, it gives the error:"An error occurred during local report processing.An error during report processing.Cannot create a connection to data source 'DATASOURCE NAME'.ERROR [HY000] [Microsoft] [ODBC Excel Driver] The Microsoft Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data. ERRRO [IM006] [Microsoft] [ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [HY000] [Microsoft] [ODBC Excel Driver] The Microsoft Office Access database engine cannot open or write to the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view and write its data.So... In before: "Is the Excel workbook definitely not open, anywhere on the network"! No, I can confirm it is not. The Excel sheet has been saved as 97-2003 and Office 12, and both deliver data top the point of Query Designer in SSRS, but will not run when Previewed...I am running on an x64 machine, so there is the BIDs x86 -> OS x64 to consider, maybe this only presents itself when previewing the report as the 'engine'(?) is different to that when just viewing the data, as opposed to running the report?Any help or new google search paths would be great, I am on, say, page 20 of google searchs containing "Excel ODBC SSRS" etc!Thanks againMon, 14 May 2012 08:26:05 GMTsimon.johnsonhttp://www.sqlservercentral.com/Forums/Topic1299245-150-1.aspxI have a stacked column chart with sales of every branch. There are about 40 branches, so it's becoming a bit difficult to view when the sales figures are displayed for each branch. Can I split the chart into two pages for better view with figures?Sun, 13 May 2012 06:52:57 GMTrajendraramahttp://www.sqlservercentral.com/Forums/Topic1298872-150-1.aspxi want to build an SSRS server that will serve reports for several different databases. in the past, where ever the prod database lived is where i would create the report server databases and SSRS would run on a seperate server.considering performance, is it better to have the report server databases on the same instance where the prod databases live OR would it be better to run SSRS and a database engine on one server and the only databases on the SSRS server would be ReportServer and ReportServerTemp?Fri, 11 May 2012 12:52:07 GMTGeoff Ahttp://www.sqlservercentral.com/Forums/Topic1299418-150-1.aspxHello,Is there anyway i can use subreport's fileds to my main report. The sub report works fine, however i need to show total from main report + subreport. thanksMon, 14 May 2012 03:11:43 GMTConfickerhttp://www.sqlservercentral.com/Forums/Topic573879-150-1.aspxI developed a report using reporting services 2005, now I am trying to see how I can get to the reporting services portal. We just installed SQL server 2005 on this server. What do I do to create the reports URL? I tried inside the server to open \\localhost\reports, it errored out. Please let me know what I need to doto browse the reporting services URL, so that I can upload the report which I just created. Thanks!!Mon, 22 Sep 2008 15:18:10 GMTMh-397891http://www.sqlservercentral.com/Forums/Topic1289400-150-1.aspxI am using a report model and need to know how to get a product with the same product name and product Id from a database. Since I cannot write SQL with the model, I would want to know how to go about this problem.Tue, 24 Apr 2012 15:26:47 GMTeobiki10http://www.sqlservercentral.com/Forums/Topic1299194-150-1.aspxI know that SSRS can render reports in MS Word but can it do so based on parameters passed to it from Word? If yes,(1) how do you pass parameters to SSRS from Word?(2) how do you render the resulting SSRS report back in Word?Situation: I need to render a report *and* pie chart inside MS Word, that is based on two parameters that a user supplies from *within* MS Word. The result is a Word document that allows the user to seamlessly relate the results of a sql query along with his/her status report, in a nice graphic way.Thank you in advance for expert advice on this forum.**Edit** I have posted gist of question to SSRS forum http://www.sqlservercentral.com/Forums/Topic1299194-150-1.aspxSat, 12 May 2012 20:18:44 GMTpolkadothttp://www.sqlservercentral.com/Forums/Topic1298466-150-1.aspxi want to get the execution time of a report, with start and end time.if any one have the solution then please send me the solution at shubhamagrawal.107@gmail.comFri, 11 May 2012 05:20:41 GMTshubhamagrawal.107http://www.sqlservercentral.com/Forums/Topic1298116-150-1.aspxI get an error that says Cannot create a connection to data source 'DataSource1'. I'm not sure what the problem is. I can Preview the report using 2005 but when I deploy and go to the Report Manager site and try to open the report I get this error. I have tried using Windows Authentication and SQL Server Authentication and neither work. Also when I click on the Data Sources folder in Report Manager it says 'There are no items in Data Sources. Click Help for more information about this page.'. Not sure why the Data Source isn't listed in that folder. There is no place to add a Data Source or anything in Report Manager. What am I missing here?Thu, 10 May 2012 12:49:16 GMTmldardyhttp://www.sqlservercentral.com/Forums/Topic1297916-150-1.aspxHas anyone had an issue with getting old information when trying to preview your report? My data source is a stored procedure. Often, if I make a change to my stored procedure, then preview my report in the BI Studio, the change does not take effect. However, if i view the report on the report website, the report runs fine, displaying the new data. I have tried refreshing the fields of the data source, but that does not help. Any ideas? thank you.Thu, 10 May 2012 08:29:56 GMTJeremy...http://www.sqlservercentral.com/Forums/Topic1295016-150-1.aspxWe are using SSRS2005 and users have access to the SSRS webpage and can see reports in format of HTML. Then they can export it to any other format if they want.Now my question is how can I show them some reports as PDF format only (i.e rather than seeing HTML they be restricted to see PDF only)??Cheers,AmirThu, 03 May 2012 19:23:30 GMTamirhh2000http://www.sqlservercentral.com/Forums/Topic1297747-150-1.aspxHi,My SSRS 2008 report manager url works fine in IE after doing settings in Security as Automatic login using current username and password. But whenever I try to access using Firefox , it's prompt for credentials. I wants it to work with Firefox as well. What I have to do so it will work in Firefox without asking for credentials? Thu, 10 May 2012 04:35:17 GMTvikramsinh.shindehttp://www.sqlservercentral.com/Forums/Topic1297737-150-1.aspxI am trying to have pagination in Report Viewer Web control. I am able to see the feature in VS BIDS and Report Manager where the page numbers are shown as 2 of ?. But ReportViewer Web control seems to render the whole report and then display? Are there any way to render only 2 to 3 pages and display and rest of the report would be shown on demand?Thu, 10 May 2012 04:22:05 GMTrlakshminarasimhanhttp://www.sqlservercentral.com/Forums/Topic1296162-150-1.aspxThe other expression I've been working at today is subtracting two fields from different datasets. Both of these fields are COUNT'd on in SQL before the dataset is populated. In other words, the syntax to populate the dataset is [code="sql"]COUNT(Person_ID)[/code]. Either way, I've been trying this:[code="vb"]=Fields!Count.Value, "KCOM_CurrentCycle" - Fields!Count.Value, "KCOM_CurrentCycle"[/code]...but I get the following error:The Value expression for the textrun 'Textbox8.Paragraphs[0].TextRuns[0]' contains an error: [BC30205] End of statement expected.I should mention that when I use the expression builder to add the fields, they come in like this:[code="vb"]=Sum(Fields!Count.Value, "KCOM_CurrentCycle") - Sum(Fields!Count.Value, "KCOM_CurrentCycle")[/code]However, it only repeats one value for each of the rows.Does anyone have thoughts on what I may be missing? I'm just breaking into the wild world of data analysis, so thanks for your patience!Mon, 07 May 2012 16:47:05 GMTDataAnalyst110http://www.sqlservercentral.com/Forums/Topic1274180-150-1.aspxI keep getting the following error: "rsRuntimeErrorInExpression The value expression for the textbox contains an error: Attempted to divide by zero.".I've tried this:=IIF(ROUND(((Fields!TG___2012_YTD.Value - Fields!TG___2011_YTD.Value)/Fields!TG___2011_YTD.Value)*100,1) & " % " IS NOTHING,"Null",ROUND(((Fields!TG___2012_YTD.Value - Fields!TG___2011_YTD.Value)/Fields!TG___2011_YTD.Value)*100,1) & " % ")And this:=IIF((Fields!TG___2012_YTD.Value) = 0,0, ((Fields!TG___2012_YTD.Value) - (Fields!TG___2011_YTD.Value)/Fields!TG___2011_YTD.Value) *100)Can anyone see what I'm missing?Wed, 28 Mar 2012 04:12:12 GMTSachin 80451http://www.sqlservercentral.com/Forums/Topic1296149-150-1.aspxOkay, this one really does have me stumped. In a header field, I want to use an expression to display today last year in MMMM dd, yyyy format. MMMM dd, yyyy. I get an error when I try this:=DateAdd("yyyy",-1,FormatDateTime(today(),"MMMM dd, yyyy"))I get 5/7/2011 12:00:00 AM (which isn't the format I want) when I try this:=DateAdd("yyyy",-1,FormatDateTime(today(),"MMMM dd, yyyy"))Would anyone know what I'm doing wrong? Thanks, as always, for the help.Mon, 07 May 2012 16:02:10 GMTDataAnalyst110http://www.sqlservercentral.com/Forums/Topic1295391-150-1.aspxI've got a report that accepts multiple parameters and presents a table of data. From that table, a user can access a more detailed report by clicking on a specific row. From the detailed report, the user can press the back button in IE and be directed back to the first report with the original parameter values still populated.This process works great in IE9. However, in IE8, the parameter values are lost when the user returns to the first report after viewing the detailed report [b][u]IF[/u][/b] the report address is something like this: https://x.y.org/Reports/Pages/Report.aspx?ItemPath=%2fsomething%2fsomething+Reports%2fReportName. Now, if I'm using IE8 with a report address something like this: http://server/Reports/Pages/Report.aspx?ItemPath=%2fsomething%2fsomething+Reports%2fReportName the parameters correctly repopulate.Here is something else that is very strange, if I'm using IE8 and I replace the "%2f" with "/" when using something like this https://x.y.org/Reports/Pages/Report.aspx?ItemPath=/something/something+Reports/ReportName, the parameters correctly repopulate.The goal is to access the report securely (i.e. https) and use the back button in IE without needing to build a custom back button.HELP!!!! ;-)Fri, 04 May 2012 10:26:05 GMTheb1014http://www.sqlservercentral.com/Forums/Topic1249658-150-1.aspxHi, just looking for opinions on SSRS scale out deployment.What I have is a cluster where the databases will sit and two separate servers for SSRS scale out deployment. I need SSRS to be flexible enough to work with different applications and lots of different sets of end users.Option 1.Install multiple instances SSRS on both the SSRS servers and configure them in a scale out deployment with a NLB. eg Option 1.Install multiple instances SSRS on both the SSRS servers and configure them in a scale out deployment with a NLB. eg SSRS server1 .--|. .SSRS-1. . . . . . .|. .SSRS-2. . . . . . .|---->|----|--> http:\SSRS1. .SSRS-3. . . . . . .|---->|NLB| --> http:\SSRS2. .SSRS-4. . . . . . .|---->|NLB| --> http:\SSRS3. . . . . . . . . . . . . . .|---->|----| --> http:\SSRS4SSRS Server2 .--| . .SSRS-1 . .SSRS-2. .SSRS-3. .SSRS-4This way I can have different versions (SP/hotfixes) to each SSRS site and each site specific to the user group.Option 2.Have two SSRS instances on a scaleout deployment and control user groups access using folders on the SSRS web site egSSRS server1. . . --| . SSRS-1 . . . . . . . .|---- --- --> http:\SSRS1\group1 . . . . . . . . . . . . . . . .|----NLB -->http:\SSRS1\group2 . . . . . . . . . . . . . . . .|----NLB --> http:\SSRS1\group3. . . . . . . . . . . . . . . . |------- --> http:\SSRS1\group4SSRS Server2 . . --| . SSRS-1 This option restricts me to have all user groups to use the same version of SSRS as well as all downtime for maintenance affecting all users at the same time.I'm inclined to option 1 as that gives me more flexibility, but the initial design here is for option 2. So just looking for opinions/experience of other DBA's on either solution.Thu, 09 Feb 2012 06:48:17 GMTShirazhttp://www.sqlservercentral.com/Forums/Topic1289463-150-1.aspxI have a report that contains embedded JPEG and PNG images. The images are sharp when the report is rendered in the Report Manager (Browser is IE 9). They look very fuzzy when the report is rendered to PDF. Are there some general rules about how to work with images when the report render format will be PDF? Are there some resources out there on this. Thank you for your help. cdun2Tue, 24 Apr 2012 18:02:20 GMTcdun2http://www.sqlservercentral.com/Forums/Topic1297202-150-1.aspxHave a new install SSRS 2008 R2, blank and empty but databases are created, on new hardware.Have an existing SSRS 2005 with lots of reports on an different server. Migrating, not upgrading in place.After some reading, it looks like I should have installed but not configured SSRS 2008 R2, and then brought over the databases from 2005, and went from there.Can I restore over the 2008 databases, or should I uninstall SSRS 2008 R2 and just start over?Wed, 09 May 2012 09:30:02 GMTMichael Gerholdthttp://www.sqlservercentral.com/Forums/Topic1296924-150-1.aspxHi All,I need someone assistance on this. At the moment I have problem when connecting Report Server. The error says 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) (rsRPCError) Get Online HelpBad Data. (Exception from HRESULT: 0x80090005)And I tried some solutions by googling here and there but I still couldn't solve it. And there is one one solution that I have not tried yet. and it is deleting encryption Key. Why do I want to try deleting encryption key? it is because I couldn't change it. the button change and backup are disable and I can not restore because there is no backup.So My concern now, If I delete Encryption. Will it delete all existing reports? and will it create a new key automatically then I can access the reports?Thanks,AndriWed, 09 May 2012 00:52:53 GMTandritjiahttp://www.sqlservercentral.com/Forums/Topic1296046-150-1.aspxPer my understanding SQL Server Report Manager is embedded in the Report Server service and cannot be installed by itself. If I want to run Report Manager and Reporting Server on two different physical servers, how may SQL Server licenses that I need to procure (i.e. is it 1 or 2)?Thanks!Mon, 07 May 2012 12:55:06 GMTsppdba