.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Reporting Services 2005 accessing SQL 2008

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :Sql Server
 
I saw a post that Reporting Services 2005 can access SQL 2008 databases.  I see this as well.  However when I attempt to use the Visual Designer I get the error message:  This server version is not supported.  You must have Microsoft SQL Server 2005 Beta 2 or later.  Is there a way to get the Visual Designer for the SQL Client to work?
Larry Charlton


View Complete Post


More Related Resource Links

Run Reporting services 2005 with databases housed on SQL Server 2008?

  
Hi, I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

Run Reporting services 2005 with databases housed on SQL Server 2008?

  
Hi, I posted this in the RS forum as well but was thinking it would be better here. I'm not sure if I can move a post to  a different forum or not so sorry for the double post. I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

Installing reporting services 2008 on machine that already has reporting services 2005

  

Hello everyone

 

I'm a novice when it comes to installing sql server and I would like to install reporting services 2008 on a machine that already has reporting services 2005 installed on it. This is a machine used for developing reports and is not used as the report server. I want to be able to develope reports in both BIDs 2005 and BIDS 2008.

I ran the sql server setup and when it comes to the screen that allows you to select the components to install, I noticed that you could create a new instance for reporting services 2008 but BIDS comes under the share components section.

If I was to select this option, would it over-write/upgrade BIDS 2005. Could someone please point me in the right direction on how to have a side by side installation of reporting services 2005 and 2008 including BIDS for both versions?

Thanks

Rob

 


Reporting Services SQL 2005 .Net 4 compatibility?

  

I've been working on my first asp.net application and for the most part it's been pretty smooth.  Right now I'm having trouble getting reporting services working under SQL Server 2005.  I developed the site with Visual Studio 2010 and didn't think about any of the .Net 4.0 compatibility issues that have arisen.  I'm having no problems with the site communicating with SQL Server 2005 for the regular database stuff.  The only problem I'm having is with setting up Reporting Services.  I have the .Net 4.0 framework installed on the server, however Reporting Services is still using 2.x.  I'm not sure if this is a problem with SSRS or with IIS.  When i go to localhost/Reports it's reading my web.config for my application and throwing an error: "Parser Error Message: Unrecognized attribute 'targetFramework'."  This is referring to a line in my web.config where targetFramework is set to 4.0.


Software that I'm using:

  • Visual Studio 2010
  • SQL Server 2005 Standard
  • IIS 7.0
  • .Net 4.0

Any suggestions?  


Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page

  

how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services

 

Thanks in advance


SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services

  

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006


Data Points: Report Controls in SQL Server 2005 Reporting Services

  

Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006


Data Points: Designing Reports with SQL Server Reporting Services 2005

  

Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006


Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint

  
Hi,

I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies



Any help will be very appreciated!

Thanks,
-Raj

Excessive Deadlocking Reporting Services 2008 Integrated.

  
Hi, we have a major issue with deadlocking on our reporting Server TEMPDB (REPORTSERVERTEMPDB). The platform is a Sharepoint Integrated platform allong the following lines 2 WFE Servers (NLB) 2 Sharepoint application servers 2 SQL Reporting Services (NLB) Cluster hosting Sharepoint DB's Cluster hosting Reporting Services DB's and the Data. This error is occuring for both manually running reports via sharepoint and load testing, and is happening on our testing platform as well which is slightly different in configuration. Reported back to the users is "An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database" Running a profile with 1224 set, we are finding deadlocks on the REPORTSERVERTEMPDB on PK_SNAPSHOTDATA. We have tried the following 1. Dropping the PK - The deadlock was then showing an OBJID which we could not identify. 2. Change the database properties to READ-COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION to ON 3. Re-create and change the PK to ALLOW_PAGE_LOCKS OFF None have these have had an impact on the issue This has become apparent since the following actions were taken 1. The setting of caching has been enabled by the developers 2. The Report Server DB's were moved from the Sharepoint Cluster to the Data Cluster. I do have an XDL file from Profiler but it is to

SQL Server 2005: Install reporting services - which version?

  
Hello - I installed SQL Server 2005 as part of an SBS2008 install. I need to install reporting services, but now I'm having trouble identifying which version (X64 or X86) I'm running. Is there an easy way of figuring out which installation disk I need to insert for SQL Server 2005? Thanks, Nick.

SQL Server 2008 Install failure - Reporting Services Rule Failures

  
I'm installing SQL Server 2008 on Windows 7.  I'm going through the install and on the "Installation Rules" page I have two failures: Reporting Services Catalog Database File Existance Reporting Services Catalog Temporary Database File Existance Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation" Clicking the "Help" button tells me to "Rename, move, or delete the files" This is the only information I can find on this exact failure.  I'm not technical enough to know exactly where these files are or what they are named.  I cannot proceed any further without correcting this issue.  I'll include some of the shorter summary log files.  I can include other detail log files if that would help. Thank you so much for any help. Select Log Files: SUMMARY GLOBAL RULES LOG: Overall summary:   Final result:                  Passed   Exit code (Decimal):           0   Exit message:                  Passed   Start time:                &n

Kerberos issue with SQL Reporting Services 2005 on Server 2003 R2

  
Hi Guys,apologies if this is the incorrect forum, so moderators, feel free to move it to SQL/IIS/SharePoint as appropriate... [Windows Server Security moderator pushed me this direction]I have a test environment that I'm trying to get SQL Reporting Services 2005 SP3 working in integrated mode with SharePoint 2007 SP2.The environment is all in VMWare, running Server 2003 R2 x86 and is layed out like this:SERVER A:AD/DNS/DHCPSERVER B:SQL 2005 SP3 CU8SERVER C:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82SERVER D:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82Through the use of DNS and (SharePoint) Alternate Access Names, SERVER D is used to deliver the Main Content in SharePoint and the Reporting Service website.  SERVER C is used to deliver the Central Admin, SSP and MySite.I've set up SPN's for the SharePoint App Pools, using the following: [main content] setspn -S HTTP/SERVERA DOMAIN\AppPoolUserA setspn -S HTTP/SERVERA.FQDN DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB.FQDN DOMAIN\AppPoolUserA [repor

Windows service can't use Reporting Services on SQL Service 2008 R2

  
Hello. I have a Windows service that run as Local System account. The service uses the Reporting Services ReportService2005.asmx web service. When I have SQL Server 2008 installed, I have no problems and my service is able to browse and create report. After I have installed SQL Server 2008 R2 I get the error "The request failed with HTTP status 401: Unauthorized." when the service tries to use the web service. If I change my service to log on as a user with administrator rights, it is able to use Reposting Services again. What has changes in SQL Server 2008 R2, that doesn't allow the Local System account to use Repoting Services? And is it possible to configure Reporting Services to allow it?   - Per

Generating Multiple Excel Sheet using Reporting Services 2005.

  
<p> Hi, I'm currently developing a program using ASP.NET 2.0 (C#) and i am using Reporting Services 2005. One of the report requirements is to export a data to an excel with multiple excel sheet. Is there other way to generate multiple excel sheet using the reporting services? if yes, i would like to ask a sample code... Thanks in advance, JP  </p> 

Reporting Services 2008 Limitations.

  
Hi All, I want to share the limitaions of SSRS 2008. 1) Blank Page issue with Dynamic Columns and Rows. 2) Global Parameters Can not be used in Body of the Report. 3) Details under the adjecent Groups will have issue with data. Nevermind if i am my assumption are wrong please correct me :) Please add the limitaions and issues which i am not listed above. Thanks, Veeren.  

Problem with Subreports in Tablix in 2008 SQL Reporting Services

  
Hi,  I have set up a report to get data from an SQL Table to build a matrix of possible combinations of 2 products, works fine. For each combination a subreport should be called with row and colum value as parameter - also OK. But for most of the first and second column are the same column values handed to the subreport, for all other columns it works Deleting and recreating the matrix does not help   Thanks in advance
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend