InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 22:55:56 GMT20http://www.sqlservercentral.com/Forums/Topic1455580-1632-1.aspxHey all,I use a 2008 r2 report server (cluster of two front end servers).We are quite new to using this server - however we have noticed that for intance;I have a report - it takes 5 seconds to preview in BIDS (getting rid of cache file first). However if we deploy to the Report sever it takes longer (30 seconds+ to run). I have done a profile, captured the SQL exec statments run (5 stored procs) and they take a total of under second to run for all of them together in management studio.Now the datasource is in the US - so is the report server. I am in the UK - so in theory the report server should be quicker for the datasource in the same country.Now here is something i found very odd. If i cache the report on the report server - it doesnt speed up the rendering of the report. However if i then generate the report as a PDF - it takes 2-3 seconds to get the PDF.There is no paging (all on one interactive page) involved. There are a few basic sums (as there are 7 pie charts).Any ideas what to look at next?DanWed, 22 May 2013 09:36:58 GMTdanielfountainhttp://www.sqlservercentral.com/Forums/Topic1452684-1632-1.aspxI have a solution with 13 reports. 11 reports deploy fine. 2 of them do not. I have done everything i can think of as far as permissions and roles, but can not get these 2 reports to deploy. They used to deploy fine before switching our domain. I believe that i had restricted permissions as well for these reports in the past so that they didn't inherit from the parent. This is the error that i receive:Deploying to http://subversion/reportserverDeploying report '/tpms/Employee Hours'.Error rsAccessDenied : The permissions granted to user 'ASNTPDC1\boutwater' are insufficient for performing this operation.Deploy complete -- 1 errors, 0 warnings========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==================== Deploy: 0 succeeded, 1 failed, 0 skipped ==========I think it is because the only permissions that they have is my old domain username. The problem is, i can't add my new domain username since I can't see these reports in the report server manager. Is there some way to remove these old reports and deploy new? Or is there some way to give my new username permissions to the old reports?Tue, 14 May 2013 09:40:53 GMTmat inwaterhttp://www.sqlservercentral.com/Forums/Topic1449845-1632-1.aspxThis only seems to happen when the server is busy; I run an SSRS report and it returns:[i]• An error has occurred during report processing. (rsProcessingAborted)o Cannot read the next data row for the dataset dsCustomerList. (rsErrorReadingNextDataRow)  For more information about this error navigate to the report server on the local server machine, or enable remote errors[/i][hr]So I talk with IT, they enable remote errors and when I run the SSRS report again, I get the error:[i]An error has occurred during report processing. (rsProcessingAborted)Cannot read the next data row for the dataset dsCustomerList. (rsErrorReadingNextDataRow)Transaction (Process ID 283) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.[/i][hr]I can run the exact same SQL query the report uses in SSMS and the query comes back in 20-45 seconds. Am I wrong in thinking that this is a SSRS problem and not in the query?Is this a SSRS problem? or a DB problem? Do I need to look into DB deadlocks?Any help appreciated.Thanks,RobMon, 06 May 2013 12:53:42 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1451795-1632-1.aspxI am using SQL Server 2012 SSRS. My DBA refuse to give me rights on ReportServer and ReportServerTempDB. He is asking me the reason why I need even access to DB. I also offer to compromise with having read only rights but his goal is to minimize giving out rights developers...My question is to ask this community is if they have ever faced situation like this. To me these both database are not part of System database so why he is hesitate to given us right?Please help.Fri, 10 May 2013 19:38:31 GMTkeyun21http://www.sqlservercentral.com/Forums/Topic1450104-1632-1.aspxUsing SSRS 2008 R2.I have one user who gets this error the first time he clicks a drill-through report (go to report action). The drill-through action is usually successful for the user on the second attempt. Only one user is reporting this error. I believe the requested url should be /Reports/Pages/Folder.aspx Help please.Server ErrorThe resource cannot be found.[b]Description:[/b] HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name chaanged, or is temporarily unavailable.[b]Requested URL:[/b] /Reports/Pages/The reporting error log show this:ui!ReportManager_0-35!728!05/07/2013-08:06:42:: Unhandled exception: System.Web.HttpException: File does not exist. at System.Web.StaticFileHandler.GetFileInfo(String virtualPathWithPathInfo, String physicalPath, HttpResponse response) at System.Web.StaticFileHandler.ProcessRequestInternal(HttpContext context) at System.Web.DefaultHttpHandler.BeginProcessRequest(HttpContext context, AsyncCallback callback, Object state) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)Tue, 07 May 2013 06:48:53 GMTPatrick Womackhttp://www.sqlservercentral.com/Forums/Topic1450822-1632-1.aspxHelloWe are using a data driven subscription (SQL 2008 R2) to email recipient specific data to an exchange server in an external domain. All of the users but one say they receive their emails just fine. We confirmed that we have proper email address information for the user in question and that the report runs fine when you manually specify that user. There are no error reported by the subscription itself. They also say that email filters are not the issue.Is there any way to verify that an email delivered by a data driven subscription has been received by a specific user in an external domain?Thanks in advance for any advice.Wed, 08 May 2013 16:11:17 GMTjshahanhttp://www.sqlservercentral.com/Forums/Topic1450251-1632-1.aspxI am using SQL Server Login:We are migrating to 2008 R2 and Reporting services keeps telling me my login failed. I set it up the same way as 2005... ie created the Login and the databases still have the user. I can connect using that Login in Management Studio, but for some reason my Data Source fails. I even tried creating the data source new.. but same login failed. (the instance's log also shows login failure when using Reporting Services Stored Credential)What the heck is going on?Using VS I opened up the project (thus converting it to 2008) and then posted to the new server.Tue, 07 May 2013 10:47:38 GMTdwilliscphttp://www.sqlservercentral.com/Forums/Topic1448190-1632-1.aspxYesterday we started seeing some reports fail. The report contains 2 subreports. Subreport 1 contains 3 charts. Subreport runs fine on its own, but all of the sudden it is timing out on the main report when I run it on a remote machine through the web interface. It "sometimes" also runs fine and sometimes times out on the report server. I am seeing this command being executed when I query DMVsselect * from {IRowset 0x2002E2A600000000}Anyone know what this is?Tue, 30 Apr 2013 12:21:54 GMTSQLKnowItAllhttp://www.sqlservercentral.com/Forums/Topic1446133-1632-1.aspxI'm looking for either help on an issue or to see if somebody can point me in the right direction to troubleshoot the issue below.We have reports running in SSRS 2008 R2 SP1 (10.50.2500.0) where a subscription on a shared schedule will sometimes show as hung up in a "pending" state. From looking through the execution log table I found that an execution log record that is normally written wasn't. I have attached a screenshot highlighting the record that was missing a duplicate that day as well as a 0 byte count. I also looked through the SSRS log files (Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles) and they look identical to previous days when I search by report name as well as the SubscriptionID for the scheduled run time. When I rescheduled the subscription to run it executed without a problem. I would like to see if anyone has any advanced troubleshooting techniques that I can employ prior to calling in a ticket with Microsoft. My client is really coming down on me to come up with an explanation for these random report failures and at this point all I can say is "I don't know".Any help, suggestions or comments are appreciated.ThanksWed, 24 Apr 2013 11:23:38 GMTjlsportyhttp://www.sqlservercentral.com/Forums/Topic1447600-1632-1.aspxHi,My set up is: SQL Server 2008 R1 32bit.What i am trying to do is set up a data driven subscription service that will automatically email approx 2000 students an individualised copy of their exam timetable (I work at a college). (I'm actually trying to use Data driven subscriptions to send out lots of different types of reports automatically to email addresses, these include confirmation of enrollment reports, timetable reports and a whole manner of different reports to our students. We have around 5000 students in total ... So i guess that would be the maximum number that we would be emailing.Data driven subscription services seems to do this extremely well, except after about the first 100 emails it sends it stops sending and all i get is the error from the SMTP server"The message could not be sent to the SMTP server. The transport error code was 0x800ccc67. The server response was 421 4.3.2 The maximum number of concurrent connections has exceeded a limit, closing transmission channel".Unfortunately the SMTP server is out of my control, and I've had a look around on topics and they all suggest that the maximum number of concurrent connections should be set higher to the max number of recipients ..... however this isn't really an option as I don't have control over this server and settings.My question is this, is there anything that can be set in SSRS to limit the number of concurrent connections its making to the email server? Can it be set to send just a few emails at a time?? It doesn't matter that this would take a while to get through them all, it would be fine if it took hours or even days to send as at the moment its just falling over because its trying to send all at once.Any help will be very much appreciatedMon, 29 Apr 2013 09:17:09 GMTa.wilkinsonhttp://www.sqlservercentral.com/Forums/Topic1440317-1632-1.aspxI have two identical SSRS 2008 servers, which are behaving differently when users attempt to access SSRS. On the first (QA) users can access reports without needing to enter a user / password. On the 2nd server (Prod) the users are asked for their domain login, and if they are not added into an SSRS role, denied access.The *ONLY* differences I have found are the following:On Prod, IIS is configured for Windows Authentication (both servers have IIS installed and running)On Prod, the certificate used for SSRS is the server self-signed, while QA has a cert (likely from the domain authority)*ALL* configuration settings between the two instances of SSRS (with the obvious exceptions of the DBs, and the service accounts {which are domain accounts for just this purpose}) are the same. I've even looked in the rsconfig.xml files on both and checked the authentication settings (WindowsNTLM)Any help would be appreciated on getting this resolved (I need both to behave like QA)Thanks,Jason A.Tue, 09 Apr 2013 07:36:18 GMTjasona.workhttp://www.sqlservercentral.com/Forums/Topic1444189-1632-1.aspxHello,I have a problem and I need an advice to solve it. I've made some reports locally in an asp.net website in C# and everything worked fine. Now I want to move them on a Reporting Service Server.I've build the local reports in this way:- each reports has a datatable in a data set. The data in that table is loaded dynamically from code. I have this code for this:[code="vb"] ReportView.LocalReport.ReportPath = "Modules/Reps/ReportOp.rdlc"; ReportView.LocalReport.DataSources.Add(new ReportDataSource("Reports_DataSet_dtOp", GetData()));[/code]GetData() is a method that returns an IQueryable instance with the data that needs to be inserted in the table used by the report.I don't know if this method works in Remote mode, and if is working how can I add the Tables used by the report and how can add data in those tables. I don't want that the reports could access the database directly.Thank you.Thu, 18 Apr 2013 16:52:17 GMTdpv_rohttp://www.sqlservercentral.com/Forums/Topic1443519-1632-1.aspxI've been tasked to figure out the specs for the reporting server. I was thinking of loosely basing it off our production server, which has the following specsProcessor: Intel Xeon X7350 @ 2.93 GHz (2 Processors)Memory: 32 GBOperating System: Windows Server 2008 R2 Server Standard (64 Bit).Storage: 1.3 TBAny suggestions would be great. The reporting database is going to be pretty small, but I want a copy of production database, in case I ever have to do ad hoc reporting.Wed, 17 Apr 2013 15:49:07 GMTDVSQLhttp://www.sqlservercentral.com/Forums/Topic1432290-1632-1.aspxHello -I have a question about granting/denying item-level permissions within Reporting Services. Here's an example of what I need to do. I need to create 2 folders for departmental reports. Each department should only have access to their own report folder and associated reports. Each department will have admin users who will create and publish reports to the appropriate report folder. The tricky part is... I would like to grant access for those admin users to create, modify, and publish, but not delete. I do not what the admin users to delete or overwrite the report.I think I have the majority of permissions figured out but I do not know how to handle the item-level permissions such as "delete". I am okay with the user deleting a report if I can track it. So if a user comes to me and says "someone deleted my report"... I want to be able to audit this action.I would appreciate any advice/help!MikeMon, 18 Mar 2013 11:55:21 GMTmikehunsakerhttp://www.sqlservercentral.com/Forums/Topic1424080-1632-1.aspxHi All,I have a slight problem and I was wondering if anyone could give me some advice or maybe a link to a similar issue. I rebuilt my test environment last week and everything went great, I thought I had it all figured out and went off to enjoy my weekend (as you do) :-D however, yesterday I was going over my test version of our customer site and found the one kink in the system and I have no idea where to start :unsure: The site allows customers to view their data and all but one report are working perfectly. When I run the site locally on the test server in IE it works great, but when I try to view it on my PC the report in question flashes up the loading box and then disappears to leave me with a blank page. I know its not a styles problem or something simple like an overlapping div, or an IE issue, and because I'm not getting an error I don't know what to try. I've gone over my indexes and used SSMS to connect to the database from my machine and run the query for the report and it all works fine :crazy: Any help would be greatly appreciated, I've listed some specs below:Kind Regards,CraigSpecs:Windows Server 2008 R2SQL Server 2008 R2Report Viewer 10.0Internet Explorer 9Tue, 26 Feb 2013 07:35:35 GMTcraig.dixonhttp://www.sqlservercentral.com/Forums/Topic1441448-1632-1.aspxHi,I need to get the name of the Report Server dsn details for a given SSRS instance programmatically.I'm aware that I can get this by going into the SSRS Configuration Manager GUI.I'm also aware that this information is written to the RSReportServer.config file, but it is encrypted.I've seen RSConfig.exe, but it appears that while this will set the DSN information, it can't retrieve that info.Is there any way to retrieve the dsn details from the RSReportServer file, or from anywhere else?The reason that I need this is that in our environment for testing purposes, we regularly change the database that SSRS is using.We therefore need to know what database is being used at a given time.Thank you for your helpSteveThu, 11 Apr 2013 13:02:21 GMTSteve Smith-163358http://www.sqlservercentral.com/Forums/Topic1429507-1632-1.aspxHi all,Here's the scenarioProduction SSRS is on SQL 2005 SP3.DR SSRS is on SQL 2008I've got a backup from the Production SSRS and want to use it on the DR box.When I point the SSRS instance on DR to a restore of the Production backups I getthe version of the report server database is either in a format that is not valid"The found version is c.0.8.54. The expected version is c.0.9.45 (rsInvalidReportServerDatabase)Has anyone been able to do what I'm trying successfully ?I had hoped that the SSRS configuration utility on SQL 2008 would apply the necessary changes to the ReportServer database to bring it from the SQL 2005 schema to the SQL 2008 schema ?Any help appreciated !Mon, 11 Mar 2013 15:40:33 GMTJoseph Fallonhttp://www.sqlservercentral.com/Forums/Topic1435004-1632-1.aspxAll of the articles I found deal with modifying IIS to speed up report manager, but I'm running in native mode and have very few options that I can modify. When developing on my PC (I'm running against the same database), the reports are extremely fast, nearly instantaneous. However when I run the same reports in report manager, it's slower. Not unusably slow, but where my development environment takes only moments to return a result, Report Manager is taking 3-4 seconds. In our environment those 3-4 seconds add up and begin to matter. Im running on a virtual 64-bit Win 2008 R2 SP1 Standard server. I've got 8GB of memory allocated to it and I've given SQL 6 of that. Should I try allocating more memory or taking a little bit away from SQL?I'm hoping there might be some configuration changes that I could make to speed things up a bit.Thanks in advance.Mon, 25 Mar 2013 10:13:02 GMTBad_Karmahttp://www.sqlservercentral.com/Forums/Topic1438982-1632-1.aspxi have installed SQL Server 2008 R2, and i can access the report urls on the local machine where i did the install, but i cant access the links if i am on a different machine. I am not getting much of an error either, its just telling me that IE cant display the page.Thu, 04 Apr 2013 12:48:18 GMTjenny 12957http://www.sqlservercentral.com/Forums/Topic1439147-1632-1.aspxHi,I got an request to install SSRS.We got a cluster N1 [Active node and Passive Node].Now they request to install SSRS on some standalone server and create or point SSRS DB’s on to Active node.I know in standalone environments we can create SSRS services on one box and SSRS DB’s one some other box. But In my scenario SSRS services on standalone server and report server DB’s on active node [On cluster node]. Can we do this ?[May be you will say, why can’t I cluster SSRS by installing services on both the nodes. But my scenario is different and they don’t want to cluster SSRS].Can you please let me know if you need any other details to resolve this.Thanks in Advance,KrishnaFri, 05 Apr 2013 04:09:28 GMTkrishnaprasad14http://www.sqlservercentral.com/Forums/Topic1435529-1632-1.aspxDoes anybody know where the latest version of RSScripter can be downloaded from. I've tried www.sqldbatips.com, but the site seems to be down or no longer exists.I'd also like to know if the latest version supports SQL 2012. I currently have 2.0.0.17 which supports up to 2008.Thanks for any assistance.Tue, 26 Mar 2013 08:28:09 GMTlindsey.mundyhttp://www.sqlservercentral.com/Forums/Topic1432610-1632-1.aspxI have a bunch of reports that point to a production database using a shared data source. For this example, we will say DataSource1 points to ProdDB1 with user ProdDBUser. I moved ProdDB1 to new disks by using the following method:1 - Backup database. 2 - Restore database into ProdDB1_Restore. 3 - Stop all applications from accessing ProdDB1.4 - Backup ProdDB1 tlog.5 - RENAME ProdDB1 TO ProdDB1_DONOTUSE . 6 - Restore tlog backup into ProdDB1_Restore.7 - RENAME ProdDB1_Restore to ProdDB18 - Disable login access to ProdDB1_DONOTUSE9 - Bring apps back online.Everything works great with every other application and login. Go to reporting services, and it is trying to connect to ProdDB1_DONOTUSE. It is the strangest thing I've ever seen. It's happening from the reporting server and from BIDS on my desktop. I have deleted and recreated the ProdDBUser. I even deleted and recreated the datasource. I can log into the database as the ProdDBUser and it execute the same query in the report directly into the SSMS and it hits the correct database. This is only occurring in SSRS. Here is what is even more bizarre... the ProdDBUser doesn't even hit the ProdDB1 database directly. It connects to a ProdReporting database that has a passthrough query to ProdDB1. How did SSRS get the database name ProdDB1_DONOTUSE?Tue, 19 Mar 2013 06:40:16 GMTEdward Mlynarhttp://www.sqlservercentral.com/Forums/Topic1431541-1632-1.aspxHello -I have found several articles online regarding usage statistics for existing reports/users but I am trying to figure out a way to log when a new report has been added to the Report Server. I don't fully understand the ExecutionLog and Catalog tables... maybe the information is being logged but I'm not sure how to query the data.It would be very helpful to know what report has been added; when the report was added; and who added the report.Thanks in advance!MikeFri, 15 Mar 2013 07:50:05 GMTmikehunsakerhttp://www.sqlservercentral.com/Forums/Topic1431218-1632-1.aspxWhen I tried to open my report manger ( clicked URL from configuration manger), it is asking for authentication .When I type my computer name and password , it is not taking it and keep on poping up with authentication (asking username and password ) to type.Can anyone tell me how to set up this?Thanks,komalThu, 14 Mar 2013 13:22:09 GMTkomal145http://www.sqlservercentral.com/Forums/Topic1388063-1632-1.aspxHi,Different scenario..please its urgent..please explain me briefly..STARTINGApplication on window Server 2003 64bit and report server on window sever 2003 with sql server 2005We upgraded report server 2005 to sql server 2008 R2 SP2 Now from users end we faced issue with unable to load client print controlthen we send new rsclient cab files to end users to paste in windows\system32and allowed activex control to downlaod.Problem fixed and things are going cool...For some other reasons we placed the application server in the report server system means now the application and reports server on same machine which is window server 2008R2 with SQL Server 2008 R2when we are accessed the application and generating the reports same problem persists unable to load Client Print control.Amazing is that when we access application from old server we are not facing any problem but the application/ report server getting error.I goggled many things but noting..?Please do the needful as earliest....Fri, 23 Nov 2012 00:34:13 GMTanil702http://www.sqlservercentral.com/Forums/Topic1428117-1632-1.aspxI'm testing an old web form app which calls SSRS reports. The ASP.Net app for the old app was VB 6 and the old SSRS was 2005. The new ASPX version is 4.0 and the new SSRS is 2008 r2. all the code is the same However some font colours and indentations of text are not rendered correctly in the web form app. The strange thing is everything looks fine when I view the reports using the report manager web tool, but when the reports are called from ASPX pages the title font colour remains black instead of the blue specified in the rdl file (see grabs below).any ideas would really help, Thanks,Dthis 1st link shows the grab of the incorrect format when the report is called from a aspx form:https://docs.google.com/file/d/0B6rNefdd5YAIOVJ1eGc0bl9kQ2s/edit?usp=sharingand the 2nd link shows the grab of the same report is rendered from report manager https://docs.google.com/file/d/0B6rNefdd5YAIazN4b0NueEcwbG8/edit?usp=sharingThu, 07 Mar 2013 10:21:43 GMTdamien.connaghanhttp://www.sqlservercentral.com/Forums/Topic1419815-1632-1.aspxHi,I am trying to integrate an ssrs2008 with sharepoint 2010. I did all steps like:- change SSRS to Integrated mode- join SSRS server to sharepoint farm- install ssrs add-in in the sharepoint server- Install WFE in ssrs serverand stock at the level I want to add ssrs server in the sharepoint central managment.When I click the SSRS url it asks for the windows credential which is a good thing but when I enter the windows login and password it will not accept that and asking again and again for the windows login and after 4 - 5 times I'll face a blank page. I checked the log and it's says permission error!! As I am sure the windows login is OK and I can connect to other sharepoint websites with the same windows login what is missing here? I reckon the problem should be in SSRS server!!!I should say when I again change SSRS back to the native mode it works fine! Any idea?Many thanks,AmirWed, 13 Feb 2013 22:42:46 GMTamirhh2000http://www.sqlservercentral.com/Forums/Topic1407278-1632-1.aspxI have recently taken over reporting services for my organization so now I'm getting contacted whenever there are issues. Our Java web application uses the SSRS web services to access and render reports. We are regularly getting Internal Server Errors in the web application when rendering report parameters and reports. I'm not seeing errors in the ReportServerHTTP log but I am seeing errors like this:[quote]library!e38!01/07/2013-17:12:15:: Call to GetReportParametersAction([path to report]).rshost!818!01/07/2013-17:12:16:: e ERROR: ReadCallback(): failed to read in read callback.rshost!818!01/07/2013-17:12:16:: e ERROR: Failed with win32 error 0x0026, pipeline=0x00000000006DFE10.[/quote]My Binoogle skills have failed me on this one as I can't seem to find any information as to what this error means. Any tips on what it is, where to find out what is, and how to fix it will be much appreciated.ThanksTue, 15 Jan 2013 07:58:15 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic1406785-1632-1.aspxHiMy report is outputting as UTIF-8 but the bank is complaining about that. They say to use DOS, by which I assume they mean csv. I can see that I should be able to modify the url of a report to over-ride the global config settings by using '&rc:OutputFormat = csv'. But where/how do I do that?I am using Report Builder, not BIDS. Is it possible to do that there?Thanks in advance,Mon, 14 Jan 2013 08:59:06 GMTFlybridgehttp://www.sqlservercentral.com/Forums/Topic1405295-1632-1.aspxHey all,One element of SSRS i have never used is report builder. I understand report builder works much better with SSAS.I have a request for a dashboard, but there are a lot of filters - making it an unpractical request. We are currently looking to the need for each filter at the moment. But it has led me to a question.If i built an SSAS cube for this - with filters as dimensions. Then built the dashboard using Report builder. I am guessing they could then drag the measures into the filter area to change the dataset? (so they just choose the filters they want?)Am i on the correct lines here?Also is it possible to do this without giving the end users access to save the RDL`s to the server. So basically we give them the dashboard without filters and they then can add filters but not save.Thanks for any advice.DanThu, 10 Jan 2013 02:55:34 GMTdanielfountainhttp://www.sqlservercentral.com/Forums/Topic1422340-1632-1.aspxWe have a report in Report Manager, with a subscription. The subscription is scheduled to run every morning a 8:00am. There is only one subscriber. History is reporting that every few days (and the interval is not consistent - anywhere between 1 and 6 days) the subscription runs twice within a few seconds.Has anyone else seen this happen? And, if so, did you figure out why it was happening?Thanks.Wed, 20 Feb 2013 15:54:12 GMTEdwinGenehttp://www.sqlservercentral.com/Forums/Topic1421823-1632-1.aspxHello, We want to create new data source connecting to DB2 database. My boss installed OLEDB drivers for IBM DB2 onto the SSRS server.But I'm not sure on how to create a datasource i.e. connection string? Also whether to use OLEDB or ODBC connection?Did somebosy has the same issue?Thanks in adavance.Tue, 19 Feb 2013 13:12:29 GMTShree-903371http://www.sqlservercentral.com/Forums/Topic1421706-1632-1.aspxHi , I want to schedule a report every 110 days after a Quater.Example: Last quater is december 31 2012 + 110 days .So my report will run again on April 20 ( which is 110 days after last quater).Can any one tell me how to do this?Thanks,KomalTue, 19 Feb 2013 09:07:09 GMTkomal145http://www.sqlservercentral.com/Forums/Topic1419873-1632-1.aspxHi there,I have a few reports that I cached as they load a lot of data that doesn't change all day long.I created a scheduled to expire the cache.So far so good... As my DWH is depending on a lot of other systems the jobs to process the data for the reports do not finish on the exact same time.However I would like to avoid to schedule the expiration of the cache with a time buffer to be sure the data is ready of the report.Instead I would prefer to trigger the expiration through the Agent-Job that is creating the data. It nows best, when its ready ;-)Is there a way to expire the cache/force to refresh through an SQL statement/or a procedure call?MitchThu, 14 Feb 2013 01:58:26 GMTchristian.terharthttp://www.sqlservercentral.com/Forums/Topic1421118-1632-1.aspxHi All, I have a SSRS subscription that runs daily to deliver an Excel spreadsheet by email.According to the report manager Subscriptions page, it always seems to have executed successfully and on time.However, the email might turn up at any time of the day or sometimes not at all.Please could you advise where I might look for an activity log(file) that might give me some clue what's going on?ThanksPaul JMon, 18 Feb 2013 03:09:13 GMTpaul-924039http://www.sqlservercentral.com/Forums/Topic1415871-1632-1.aspxI am trying to migrate SSRS reports from SQL 2005 [Enterprise Edition-SP2] to SQL 2008 [Enterprise Edition-SP1].[Note: This SQL 2008 already got report server. Now I want migrate existing reports from SQL 2005 server to SQL 2008 RS].Can you please provide me the steps to process this without effecting/corrupting existing SQL 2008 reports/report server.please let me know if you need any other details…..Thanks in AdvanceKrishnaTue, 05 Feb 2013 08:07:23 GMTkrishnaprasad14http://www.sqlservercentral.com/Forums/Topic1418700-1632-1.aspxHello - I am trying to reconfigured SSRS on a Windows Server 2008 R2 Standard 64-bit OS system with SQL Server 2008 R2, but am unable to get to the report server page in IE after the install and config. The error is not really an error, but just a plain page that gives the name of the server/ReportServer - / and then a message below it that states 10.50.4270.0 (Which I know is just saying it sees that SP2 / CU4 is in place).I've tried both the Web Service URL and the Report Manager URL from the config tool (to make sure my syntax is correct) but to no avail. Any and all help would be appreciated.Thank you,SQL_ME_RICHP.S. By reconfigure I mean I resintall new ReportServer and ReportServerTempDB databases.Mon, 11 Feb 2013 17:48:38 GMTSQL_ME_RICHhttp://www.sqlservercentral.com/Forums/Topic1414874-1632-1.aspxSo - learned the hard way that there are Symmectric Encryption keys in the ReportServer. Was able to get it reattached and reencrypted, but now all the subscriptions have been wiped out.When we put them back together - They are hanging in status as 'Pending' and I need to get this resolved asap, but have not been able to find anything on it.This is a SQL Server 2008 R2 SSRS configuration. Databases are on one server, and the SSRS services are on another.Thank you for any and all help, and please let me know if I may provide you with any other specifics (I am very inexperienced with SSRS and may not know everything you want to know to understand my situation here better).Thanks,SQL_ME_RICHFri, 01 Feb 2013 17:33:34 GMTSQL_ME_RICHhttp://www.sqlservercentral.com/Forums/Topic1413668-1632-1.aspxWe have a named instance used for our SharePoint 2010 databases running on an active-passive cluster. (SQL Server 2008 R2-SP2 and Windows 2008 R2). Named instance=SPCLST1\SharePTWe have a separate server dedicated to SSRS 2008 (SQL Server 2008 R2-SP2 and Windows 2008 R2). Default instance name=SSRSP1We'd like to publish reports on SharePoint (SPCLST1\SharePT) that integrate with existing SSRS reports on SSRSP1.From most of what I've read to appears that you have to install SSRS onto the server that hosts the SharePoint DBs, but because SharePoint is on a cluster, this isn't allowed. (I tried it and it didn't work)Has anyone had any success getting this to work?Thanks in advance.MikeWed, 30 Jan 2013 08:44:00 GMTRML51http://www.sqlservercentral.com/Forums/Topic1410699-1632-1.aspxWe are migrating our databases to new our new servers and MS SQL Server 2008. Since almost no one is on this server, and jobs are not running yet.. why does it take over a min to pull up SSRS?http://BIServer.global.loc/ReportS/pages/folder.aspxWed, 23 Jan 2013 10:14:47 GMTdwilliscp