Can I Run SQL Server 2008 - Reporting Services CTP Until Microsoft Sells SQL 2008
Mar 31, 2008
There are a few features in the new SQL Server - Reporting Services that I really need in production. I have tested everything and it works great. I am running the CTP version since Microsoft is saying they aren't releasing the release version until 3rd quarter 2008.
Since Microsoft won't sell SQL 2008 until 3rd quarter, can I run the CTP in production until the release and then purchase SQL 2008?
I downloaded the €œMicrosoft SQL Server 2008 Express CTP, February 2008€? from http://www.microsoft.com/downloads/details.aspx?FamilyId=749BD760-F404-4D45-9AC0-D7F1B3ED1053&displaylang=en
I simply replaced the 2005 file €œSQLEXPR.EXE€? with the 2008 file €œ€?, recompiled the installation and tested only for it to fail. I than read the 2008 books online and noted the change in command line options.
I then changed the command line to suit the Microsoft 2008 books online, recompiled the installation and tested only for it to fail once more.
Interestingly I tested the install from the default GUI and at the point of adding the €œsa€? login credentials it fails to allow the installation to proceed. Strangely by selecting the windows authentication credentials, €œnext€? than €œback€? it now allows me to add the €œsa€? login credentials and continues to install correctly as required.
I hope I have explained this clearly enough.
1. Is this a bug in the €œMicrosoft SQL Server 2008 CTP, February 2008€? installation? 2. If so is this causing the command line install options to fail? 3. How do I obtain a version of €œMicrosoft SQL Server 2008 Express€? that will work installing from the command line?
if it is supported to install Reporting Services on both the active and passive nodes in an SQL Server Failover Cluster and use the non-active node as a warm standby?We have relatively simple reporting requirements so the idea would be that if Node 1 went down, we could just repoint our users are Node 2 temporarily. Both reporting services instances would be configured to target the same SSRS database running on the SQL Cluster.
We are moving to a new data center. We have RS install on appweb server that points to different sql server for Reportserver and Reportservertempdb. So, We created a new virtual appweb server and new physical database sql server 2008 r2 at new DC. I did a fresh install of new reporting services 2008 r2 on appweb server. I backed up and restored Reportserver and reportservertempdb dbs from old 2005 sql server to new 2008 r2 database server.
During new RS configuration, I pointed databases to the new restored databases and restored encryption keys. When launched reporting services URL, it works fine.
I stopped and restarted reporting services after configuration.
However, I am not seeing any single job created on new database server. Old server had 20 jobs.
How do I get these subscriptions back to the new install? I thought this should be created with migration and I do not have to do anything.
One odd thing I had to do during config was that:
In scale-out deployment tab in RS configuration, it was showing both the new and old appweb server name as status joined. I was unable to remove the old server name by clicking 'remove server' there. So, I deleted old server name from keys table in Reportsserver as suggested by some forums to have a clean installation. Does it have anything to do with jobs not created?
What do I need to do now to get subscripts jobs created. Ther eare only 20 jobs here but another RS server has over 800 subscriptions that I can not mess up. So, need to find the issue and correct it before I can move on to the another RS instance.
Hi, I have a Windows 2008 server 64-bit SP1 and I have installed SQL 2005 SP2 Enterprise Edition 64-bit. My current version is 9.00.3042.00. I am trying to configure Reporting Services and I am having lots of trouble getting the Application Pools to work properly. I have followed the Microsoft Technet paper 839480 "How to Install and Configure Reporting Services on Windows Server 2008". In the "Configure Reporting Services" part, I have successfully configured everything (all arrows are green) and have the following setup:
Report Server Virtual dir: ReportServer Default Web Site Report Manager Virtual dir: Reports Defualt Web Site Windows Service Identity: ReportServer with a service acct login Web Service Identity: Report Server: ReportServer, Report Manager: DefaultAppPool (I get an error when I try to configure it to anything else: ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 800708AC at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
The one thing I notice in the SQL Server configuration manager is that there is a red dot next to the SQL Reporting Services services even though the green arrow is there to show it is running.
When I look in IIS7, I see the application pools Reports and ReportServer and they are both in Integrated mode. When I try to go to http://localhost/reportserver, it gives an error. It will work if I change both application pools to classic. But then when I try to go to http://localhost/reports, I get an error:
"REQUEST IS NOT AVAILABLE IN THIS CONTEXT".
I have read up on IIS7 and it says that: "This error is due to a design change in the IIS7 Integrated pipeline that makes the request context unavailable in Application_Start event. When using the Classic mode (the only mode when running on previous versions of IIS), the request context used to be available, even though the Application_Start event has always been intended as a global and request-agnostic event in the application lifetime."
So, how do I configure these application pools to work using IIS7 with SQL 2005 Reporting Services on a Windows 2008 server? I have tried all kinds of different things based on what I am reading on the net and nothing is working. Anybody have any suggestions?
Hye all, running WHS 2008, I try to install SQL Server 2005 with reporting services, but on install, in "components to install" wizard, the reporting services box is hided. I can't check this box :/ Do you know whats wrong ? if anyone knows the problem, thanks in advance.
Does anyone know how to properly install SQL server 2005 express reporting services on windows server 2008. When ever i try to access the report manager I get an error "Cannot access the remote server" even though the report server is on the local machine. I only have the web server role installed on the server. Im still quite a newbie at managing servers so please keep it as simple as possible. Thanks Matthew
Will Reporting Services 2008 continue to expose its methods via Web Services (asmx) or use the new techology of Windows Communication Foundation (svc)? Or will it use both?
We built our prod server [vm] with SQL Server 2008 R2 on Server 2008 R2. It works nicely. Then we made a copy of the VM and renamed it (so our test environment would be IDENTICAL to production). After that, SSRS was broken: I get "HTTP Error 503. The service is unavailable." I can't connect via http, or SSMS.
We have tried:
*Â Running SSRS config tool (several times)
* Running with/without the IIS Server Role
*Â Dropping & recreating the SSRS keys
*Â Recreating the ReportServer database, etc
*Â Checking all of the accounts, permissions, etc
*Â Running SQL Repair
*Â Going through the registry to fix any references to the machine's old name
*Â Uninstalling, reinstalling SSRS
* Completely uninstalling ALL of the parts of SQL Server 2008 R2, deleting all directories, removing references to SQL Server from the registry, rebooting, reinstalling everything.
None of this has worked. SSRS [R2] is still 503 on our test box.
the SSRS [NT] service seems to run, without error. The Event Viewer doesn't seem to be recording any errors. The SSRS logs say that the default URL is wrong, but we get the same error in Prod, and Prod works fine. The other SQL Logs say something about not being able to contact the service. However, as I said, the [NT] service seems to be working fine.
Does anyone know if SQL 2008 Reporting Services will support generating secure PDFs?
We have seen that there are expensive 3rd party plug ins. We are not as interested in using a 3rd party plug in, because they tend to be costly and then there are maintenance issues (and in that case we may as well stick with our current separate reporting tool rather than converting to Reporting Services), but any other suggestions as to how to accomplish this in reporting services would be appreciated.
I have a matrix in one of my SSRS report data is like below
Row as Branch Column as Tasks (Progress, Completed , cancelled, In Complete)
Branch  Progress Completed cancelled In Complete   Total    %(Complete/Total) Aus          1            2              3                4                  9                     22.2% NZ            1             2              3               5                   11                     18.88% US          0             0               3                3              6                         0.00%
How can do in the SSRS matrix %(Completed/Total) percentage calculation ?
Is there anyway in SSRS 2008 to sort the Legend on a chart? Right now I am unsure as to how it is currently sorting. I see a property to Reverse the order, but I don't see anything to alphabetize it.
I have 2 datasets, dataseta is a list of tickets and their relevant owner and databsetb is a list of owners and a days worked first against them.I have a table with a detail grouping on ticketid and a normal grouping on owner which works well... all straight forward to this point. In this table on the owner grouping level I also have a lookup to datasetb which pulls back the days worked per owner which works fine as well. But what I now need to do is total the days worked over all owners, which sounds simple but doesn't work. This is the expression on the days worked for each owner -
I have a RS 2008 R2 SP3 Service in SharePoint Integrated Mode.
Since 5 days my Subscriptions were not sent anymore. I did no changes to these machines. There were some data driven subscriptions in pending state. I delete these entries via SharePoint.
When I look at Report server  Execution Logs, there is no error, that i can associate to subscriptions. New Subscription are created and deleted in the Log, but they will never been processed.
I have done a Reboot to the RS Box but, that was not the solution.
I've got an SSRS 2008 report with 4 nested groups on rows. Report requirements are that each new group at each level have a subtotal. I've gotten this to work just fine. After the users saw the report, they had a new request - if the SubTotal has only 1 row to Subtotal, do not display the Subtotal. If there are 2 or more rows, display the Subtotal line.I know I can go to the Grouping Properties, and on the Visibility properties select the "Show or hide based on the expression" - I am struggling with the experssion. How can I check to see if there are more than one row at this group level? The query is SQL with 2 sub selects, and 7 tables in various join clauses.Â
I need to have a report that will have formulas in excel. I understand that the limited support for exporting excel formulas has been dropped in SSRS 2008. Is there any way to work around this and still output formulas?obvioulsy the way to do it in previous versions of SSRS are not working (using report items). I tried to add my formulas in my dataset (I can know which excel cells I need in the formulas) but they end up being displayed as text. I then have to get in the excel file and enter and exit each cell so that it "becomes" a formula.
Can I use C# express edition 2008 with Reporting Services.
and i add 2008 report viewer component in my tool box list
while viewing the report in my solution ...i was getting the error as given below..
The report definition is not valid. Details: The report definition has an invalid target namespace "http://schemas.microsoft.com/sqlserver/reporting/2007/01/reportdefinition' which cannot be upgraded.
I'm using SQL Server 2008 SP3 with Reporting Services 2008 SP3.
By opening my web application in IE9 and running report, i can print and show then print preview by clicking the "Print preview" button in printing dialog.
By opening my web application in IE11 and running report, i can print the report but if I click on the print preview on the print dialog nothing appears... Why?
What is the best approach for turning the report below into a PivotTable report in SSRS 2008 R2?The PivotTable has the following characsteristics:
Filters:   None Columns: Mat_Month Rows:    Level1, Level2 Values:   MaturingBalances
We have an SSAS Cube with the same data (in a dimensional schema).The report (currently sourced via SQL from our data warehouse):The Pivot Table - currently in Excel but needs to be ported to SSRS
I have a Matrix with dynamic columns. I am grouping Matrix on one column group. I am trying to have a different color for every group. I hvae so far, three groups. How can I do that? A note, there is no data for every column group in every row.
I have database fields that contain RTF text. If I use the default Textbox in SSRS 2008 Report Designer, I get all the RTF formating characters, which makes for a VERY ugly report.Is there another control I can place on my report that will take the RTF formated text and display it properly? I can do this in Crystal Reports, but I'm converting to SSRS 2008 so I need to be able to handle RTF formated text.
I have a dataset in my report that pulls 10 fields. One of the tablixes on report should display only 8 of the 10 fields and this is causing the duplicate records to show up on the tablix.I tried hide duplicates option for the entire details row and have set the scope to "Details". It did not work. I am getting the data from a stored procedure and cannot do much on that.
VS 2008. I have the following set up. Group1, Group2, Group3 header, Group 3 detail rows..When I set the row visibility (hide based on Group2) on the Detail row, it still shows up when the report is originally rendered.
It should be: Group1 expanded, Group2 collapsed, Group3 header hidden and detail rows hidden It is showing: Group1 expanded, Group2 collapsed, Group3 header hidden, Group3 detail row visible.
I never had this trouble in 2005. Is there something different about row visibility in 2008?
we need the list suppliers in a text box,if it were a parameter, we can do it by =join(parameters!Supplier_ID.Value,",")but if the Supplier Id is a field , join (Fields!Supplier_ID.Value,",") doesnt work!how to achieve this.
Presently I have a main report and subreport, with the subreport having values for a carbon copy contact, which when it is displayed it shows these values:  Peter Piper    #Error    #Error   peterpiper@mycompany.com    #Error Donald Duck   #Error    #Error   donaldduck@mycompany.com   #Error etc.  When I run the subreport directly, it correctly returns all the values:  Peter Piper    123-345-6789    Calgary   peterpiper@mycompany.com    T Donald Duck   987-654-3210    Calgary  donaldduck@mycompany.com   F  Here are the details on SQL Server 2008:  Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64)  Feb 25 2011 13:56:11  Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)  why the #Error is showing up the the main report?
I've had a SSL wildcard certificate successfully in use, unless it had to be replaced because of its age. Now I've imported a new certificate, but unfortunately I'm unable to set it up in the SSRS Configuration Manager Console (Web Service URL / Report Manager URL), because "We were unable to create the certificate binding".  Here is the Error Message:  Microsoft.ReportingServices.WmiProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070520  ---> System.Runtime.InteropServices.COMException (0x80070520): A specified logon session does not exist. It may already have been terminated. (Exception from HRESULT: 0x80070520)   --- End of inner exception stack trace ---  I've also deleted the existing bond in the netsh console with "netsh>http delete sslcert ipport=0.0.0.0:443", but this still doesn't fix the issue.