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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSRS 2005 SP3 x64 on Windows 2008 R2

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server

Hi All, I was finally able to configure SSRS 2005 x64 SP3 on Windows 2008 R2 by disabling 32 bit applications.  However, I host other web applications on this server that are 32 bit. 

I am planning to only disable 32 bit apps for the installation of SSRS and then go back and enable it for the applications that need it.  Does anyone know if this will cause issues?  Does anyone run SSRS 2005 x64 on Windows 2008 R2 and also have other 32 bit applications on the same server?



View Complete Post

More Related Resource Links

Shared dataset in SSRS 2008 R2 running on SSAS 2005

I am trying to create a report in SSRS 2008 R2 using SSAS 2005 as a datasource. My dataset has a date parameter. When I create an embedded dataset in my report everything works fine, but when I create a shared dataset with the exact same mdx query, I get the following error: An error occurred during local report processing. The definition of the report 'xxxx' is invalid. The Value expression for the report parameter 'DateCalendarHierarchy' contains an error: [BC30034] Bracketed identifier is missing closing ']'. Does anybody have any ideas? Is this a bug? Thanks, Louis

How should I configure Asp.NET on IIS 6, Sql Server 2005 and SSRS 2005 across 2 Windows Server 2003

I was running a MIS reporting solution on a single server running MS Windows 2003 Server and Sql Server 2005. The solution was built using ASP.NET 2.0 on IIS 6.0, Sql Server DB & SSRS. I now have purchased a 2nd server running MS Windows 2003 Server and Sql Server 2005. What is the best configuration to split the following application components across the 2 physical servers? ASP.NET web application SQL Server 2005 Datawarehouse SSRS Web Applications (Reports & ReportServer) SSRS Databases (ReportServer & ReportServerTempDB) The hardware configuration of the 2 servers are as follows Server 1 MS Windows Server 2003 Enterprise Edition SP2 Intel(R) Xeon(R) CPU 5150 @2.66GHz 16 GB RAM Sql Server 2005 SP3 Standard Edition Smart Array P400 in Slot 1 (SAS Array A with Spare / SAS Array B with Spare) Drive C: 68.33 GB | Drive D: 273.40 GB Server 2 MS Windows Server 2003 Standard Edition SP2 Intel(R) Xeon(R) CPU X5570 @2.93GHz 4 GB RAM Sql Server 2005 SP3 Standard Edition IBM ServeRAID-MR10i SAS/SATA Controller Drive C: 135GB | Drive D: 556 GB | Drive E: 271 GB Any suggestions would be of great help

Management Studio sql 2005 Express on Windows Server 2008 r2

Hi , i have install a application that use sql server express 2005 on a server with OS windows server 2008 r2. My question is how to make automatic backup of my database , because i cant install SQL Server 2005 Management Console on my server .   Please help me Thanks

Barchart migiration problem when I move it from SSRS 2005 to SSRS 2008

Hi I am having a barchart report in ssrs 2005 which  is going to dynamically generate the bars depending on the input parameters for example if we give 15 as input it is going  to generate 15 bar on the chart and if we give 25 as input it is going to generate 25 bars on the report.Report is working well in ssrs 2005 but when I migrate it from ssrs 2005 to ssrs 2008 and run the report it is working well when i select 15 as input it is showing me 15 bar with the names on x-axis and y-axis.But when I select 25 as input it is generating bar chart  and I see multiples of 5 like(5,10,15,20)  bars are getting the names displayed on the y-axis and rest of the names are not displayed on chart.I was trying to expand the bar chart  and trying to see the different.When I expand report is spliting into two pages and I see multiples of 5 like(5,10,15,20) bars are getting the names displayed and rest of the names are not displayed.So can anyone suggest me any solution.   Thanks in Advance

Problem configuring SSRS 2008 with sharepoint 2007 on Windows server 2008

Hi All - I am unable to integrate SSRS 2008 with sharepoint 2007. I am new to this part please correct em if am wrong. I have 2 servers one for SQL and one for MOSS MOSS server. Windows server 2008 MOSS 2007 .Net 2008 with basic sql 2005 which comes default WSP builder Everything is working fine SQL server: Windows Server 2008 SQl server 2008 and configured SSRS BIDS. When I am trying to install SSRS plugin for MOSS it is not accepting on both the machines. Please help me if am missing something here. I configured sucessfully on one server but havent done on multi server environment. please help me.   Thanks Saritha    saritha k

SSRS in place upgrade from 2005 to 2008 issue


I did an inplace upgrade of SSRS 2005 to 2008 and now the reports are throwing the following error. The reports were all working fine and there is a datasource with the name 'Data Source Name' without the '_'.  Please help.

  • An error has occurred during report processing. (rsProcessingAborted)
    • The data source 'Data_Source_Name' cannot be found. (rsDataSourceNotFound)

SQL Server 2005 installation on windows 2008 cluster error


I am trying to install SqlServer 2005 on windows 2008 cluster with domain controller. Installation fails on the second node while trying to set registry settings for server network libraries. Attached error message and output from error log. Can somebody suggest any solutions.



TITLE: Microsoft SQL Server 2005 Setup

Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11004 (The requested name is valid, but no data of the requested type was found.


Func Name='LaunchFunction'>
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_SetServerSSNLDefaults
PerfTime Start: Do_SetServerSSNLDefaults : Fri Sep 24 17:45:31 2010
<Func Name='Do_SetServerSSNLDefaults'>
Setting server network settings for instance name MSSQLSERVER, instance id MSSQL.1
Failed to set registry settings for server network libraries. The action: SetDefaults Error: 11004
        Error Code: 0x80072afc (11004)
Windows Error Text: The requested name is valid, but no data of the requested type was found.
  Source File Name: sqlca\nlregca.cpp
Compiler Ti

SSRS 2005/2008 - Chart with bar graph not generating on subsequent executions of report even with mo


For a report executed from Report Manager that has a bar chart component, regenerating the report via refresh or view with same input parameters either gives a different result that is garbled or an empty chart (2008) or no chart at all (2005). I have the report set up to not do any caching, so that does not seem to be the issue. Is there some chart option I may need to set to get the proper chart display.

Report conversion from SSRS 2005 to SSRS 2008


I am converting reports developed in SSRS 2005 into SSRS 2008. In the report design interface I have several rows and columans of data that calculate count or rate. In addition to rows and columns, I have around ten hidden tablixes in which report expression calls hidden codes inside tablix to perform calculation with main report. My problem is when I set hidden tablix propert into hide, I am not getting correct calculation in my report.  when I change tablix property from hidden to show I will get correct calculation but I do not want to see those hidden tablixes in my report page. Is there any way  you can still call expressions inside hidden tablixes without turning on tablix property show in SSRS 2008? Is it a bug in SSRS 2008 reporting system? Please help me out!!

My operating system is windows vista.



SSRS 2005 to 2008 upgrade: exporting to .PDF does not produce the same result


We have recently converted .rdl SSRS 2005 files to SSRS 2008 .rdl files. We do not have SSRS 2008 R2, we are working with the  first release. We are seeing issues when exporing a report to .pdf format:

1) when rendered in HTML, the function that displays page numbers (ie:page 1 of 2) for the report are correct. The standard function "Globals!TotalPages" is used to get the count of pages. We previewed a report in html in reports manager that had 1777 pages. when the report is exported to .pdf the last page displays page 1777 of 1816, even though there is no more pages beyond 1777.

2)When rendering the report in html a value is shown as "Caretaker1" but when exporting to adobe .pdf version 9.3, the same value is shown as "Caretaker2".

3)   One of our issues is

Getting SSRS 2005 to work on Server 2008 R2


I reinstalled SQL Server 2005 x64 Standard Edition SP3 on a Server 2008 R2 box and installed IIS and SSRS as well.  SQL runs fine. SSRS is installed all configs look good, but I cannot get it accessible via the browser (//localhost/ReportServeror //localhost/Reports). 

I have tried both 32 & 64 defaults in IIS AppPools and each gives me an error and I can't find any other resources as to what the problem is?

32-bit setting is giving me this error on /ReportServer:

Could not load file or assembly 'ReportingServicesNativeClient, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.

64-bit setting is giving me this error on /ReportServer:

HTTP Error 500.0 - Internal Server Error, Error Code 0x800700c1

32 & 64-bit setting are both giving me this error on /Reports:

HTTP Error 401.2 - Unauthorized, Error Code0x80070005

Export PDF in ssrs 2008 vs ssrs 2005 - pdf is different, won't work with itextsharp (possibly other

We're migrating from SSRS 2005 to SSRS 2008. We use itextsharp (a pdf processing library) to merge different PDF outputs into one large PDF file. This was working brilliantly in SSRS 2005, but in SSRS 2008, itextsharp *can* open and parse the PDF, but itext sees the "content" section of the PDF pages as blank. So, the resulting composite PDF ends up being a series of blank pages. Acrobat 9 and a couple other PDF tools (tested linux Evince and win GIMP) seem to be able to open the SSRS 2008-generated PDF fine, but the java-version of itext, and the .net version of itext (itextsharp) see nothing but blanks.
So, I realize this points to a problem with itext, but I'm curious if anyone else is merging PDFS outputed from SSRS 2008, and what PDF tools/libraries they are using.

Much thanks!

Windows authentication using SSRS 2008 R2 on separate machine from SQL db engine - Kerberos required


Is this still an issue in SSRS 2008 R2:  Can't use Windows authentication (integrated security) when the SQL database server is on a different machine than Reporting Services -- unless you (1) use Kerberos security, or (2) store credentials, or (3) use credentials supplied by the user when running report AND use as Windows credentials to impersonate?

I have SSRS 2008 R2 set up on a different machine than MSSQLServer 2008 R2.  When I create a report on the SSRS server that uses a data source specifying Windows integrated security, my symptom is that I get the following  error:

Cannot create a connection to data source 'myDataSource'. ---> System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Here is a blog describing the problem under SSRS 2005 (with IIS): http://blogs.msdn.com/b/jgalla/archive/2006/03/16/reporting-services-and-windows-authentication.aspx



Richard Thompson

SSRS 2005 & SSRS 2008


Hi i have some doubt in configuring the web service address for both 2005 & 2008.

I do have 2005 in my system also have installed the trial version of 2008.

Previously i used to deploy reports to localhost/reportserver for 2005 and it was well.

But after deploying 2008 reports to the server <SystemName>:8080/ReportServer_SQL2008, its found that the ocalhost/reportserver to be not working. WHen verifying with its configuration the web service address was left blank (2005).

I tried changing the port number in the 2008 configuration (<SystemName>:8080/ReportServer_SQL2008 to <SystemName>:7979/ReportServer_SQL2008) but the reportserver page is opening where as <SystemName>:7979/Reports_SQL2008 is not opeing saying 'HHTP 04 Bad Request'

Isn't possible to have 2 different adreses to be working for 2 different servers?

if not kindly let me know the configuration to be done for tht..

THanks !!

--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Migration of Analysis Services 2005 Cluster (Windows 2003) to Analysis Services 2005 (Windows 2008)



I need to migrate my SQL Server and Analysis Services cluster from Windows Server 2003 to Windows Server 2008, I have found an article for SQL ID (953200), but I cannot find anything for Analysis Services, does such a guide exist?




SQL Server 2005 on Windows 2008 R1/R2 64bit



Please advise where can I find the product compatibility matrix for SQL Server? I need to know if SQL Server 2005 (64bit) is certifed on Windows server 2008 R1/R2 (64 bit).



Need the help while installing the MS SQL 2005 Express edition on windows 2008 server.



I want to install MS SQL 2005 Exp. edition in windows server. For that I had already downloaded the SP2 MS SQL 2005 exp. edition from Microsoft web site. I am geeting error while trying to install SQL: "The SQL service failed to strat . For more information see the SQL server books online topics, "How to view SQL server 2005 setup log files and starting SQL server manually." Our Server configuration is windows 2008 R2 with 32 bit prcessor.

Before that i had install the same but SQL Server Management Studio icon is not showing, so I unstalled SQL and then trying to fresh installation.

Please help me to resolve this issues.

Thanks in advance.

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