Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005 SP2   (RSS)
Thursday, October 15, 2009 2:00 AM

Reporting Services and the MS09-062 GDR (GDI+)

Updated 10/29/09:  Added section describing SQL Engine only servers at the bottom.   Brian Hartman did a great job outlining what the GDR is and why we had it.  You can read it here .  I’m not going to rehash that here.  What
Posted by psssql | 0 Comments
Thursday, June 18, 2009 4:59 PM

Zero Byte Attachments in Email Subscriptions

I had an issue a while back with RS 2000 where we would get a Zero Byte attachment when hitting a Lotus Notes server.  This ended up being corrected in KB 872774 . So, when I was assigned a case with a similar description, but this time with RS 2005
Posted by psssql | 0 Comments
Monday, May 18, 2009 5:53 PM

Upgrading Windows with RS 2005

From an IIS perspective, there were changes between IIS 6 (Windows 2003) and IIS 7 (Windows 2008).  Reporting Services 2005 utilizes IIS for the Report Manager and Report Server Web Service.  If you had a Windows 2003 Server with Reporting Services
Posted by psssql | 1 Comments
Thursday, May 07, 2009 3:08 PM

SSIS 2005 and the .NET Garbage Collector

I was troubleshooting an SSIS Out of Memory issue the other day which led us into how the .NET Garbage Collector (GC) works.  When debugging it, I found that we were using the Workstation GC with Concurrent GC On (this is the default for .NET applications). 
Posted by psssql | 1 Comments
Monday, February 02, 2009 2:37 PM

Why aren't my subscriptions working?

I ran across an interesting issue the other day with subscriptions not firing.  I had never ran across this before, but once I was done it made sense.  It was also a good exercise of walking through how subscriptions work.  This may be
Posted by psssql | 1 Comments
Monday, December 29, 2008 4:41 PM

Failure to load Report Manager due to truncated UserAgent string

We came across an issue when trying to load Report Manager.  We would get the following exception: System.ArgumentException: Version string portion was too short or too long. at System.Version..ctor(String version) at System.Web.Configuration.HttpCapabilitiesBase.GetClrVersions()
Posted by psssql | 1 Comments
Tuesday, September 23, 2008 1:24 PM

Reporting Services Windows Service will not start after applying MS08-052

We have been seeing a few cases where the Windows Service for Reporting Services will not start after applying the following fix: MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008 http://support.microsoft.com/kb/954606/
Posted by psssql | 2 Comments
Wednesday, July 23, 2008 7:45 PM

SQL Server 2005 Encounters Exception During Install When System has Odd Number of Processors or Logical Processors Per Core

While attempting to install SQL Server 2005 you may encounter an error familiar to the following and a retry option presented by setup. Faulting application sqlservr.exe, version 2005.90.1399.0, time stamp 0x434f82e9, faulting module sqlservr.exe, version
Posted by psssql | 3 Comments
Thursday, May 31, 2007 5:15 PM

The SQL Server Working Set Message

Work continues around the working set issues. You can find the latest and greatest Information: http://support.microsoft.com/kb/918483 =========================================================== I spent several days last week investigating reported case
Posted by psssql | 14 Comments
Friday, April 06, 2007 8:31 PM

SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained

The dust has now settled after the release of SP2 for SQL Server 2005 so I thought I would take some time to explain a few details about the re-release of Service Pack 2 and the fixes that have been posted by Microsoft since this re-release. There is
Posted by psssql | 27 Comments
Filed under:
Friday, March 30, 2007 7:52 PM

SQL Server 2005 Performance Dashboard Reports

The SQL Server 2005 Performance Dashboard reports were recently released as a free download for customers. The performance dashboard was developed as a joint effort between the support and development teams with a goal of reducing the amount of time spent
Posted by psssql | 4 Comments
Wednesday, February 21, 2007 4:55 PM

SQL Server 2005 Service Pack 2 has released! Linked Server GUI is back!

SQL Server 2005 Service Pack 2 (SP2) released on Monday to the web. If you want to start downloading it while reading the rest of the post, go right to http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx . Over the next
Posted by psssql | 0 Comments
Attachment(s): test_linked_server.bmp
 
Page view tracker