Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Adam   (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
Wednesday, September 30, 2009 12:57 AM

Reporting Services: What’s my version?

I was working on a case where I needed to try something on different Cumulative Updates (CU) to see what the result was in each.  Let me outline the version numbers for the Service Pack 1 release we have to date. Release Version Number SQL 2008 RTM
Posted by psssql | 0 Comments
Wednesday, July 01, 2009 10:12 PM

When in doubt, Reboot!

I tend to get quite a bit of Kerberos related cases.  These are related across the box, from the Engine, to Reporting Services to just straight connectivity with custom applications.  I had one given to me yesterday because the engineer had
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, March 05, 2009 10:21 PM

SocketException when creating a new Report Server Database

We had a customer call up that encountered a problem when trying to create a new database for their Report Server through the Reporting Services Configuration Manager.  This is what they saw: When we clicked on the Error link, we saw the following
Posted by psssql | 2 Comments
Friday, February 13, 2009 4:16 PM

Searching for Duplicate SPN's got a little easier

We get a lot of calls related to Kerberos configuration, and I'm planning to write more about our experiences and troubleshooting techniques for these types of issues across the box (Engine, AS and RS). With Windows 2000/2003 SetSPN had only a few commands
Posted by psssql | 2 Comments
Tuesday, February 10, 2009 8:37 AM

How to troubleshoot leaked SqlConnection Objects (.NET 2.0) - Part 2

In the last post in this series, we looked at how we can determine that our Connection pool was exhausted. In this post I'm going to go a little deeper into the Internal connection itself and how we can verify if this is a closed or active connection.
Posted by psssql | 0 Comments
Thursday, February 05, 2009 8:54 PM

How to troubleshoot leaked SqlConnection objects (.NET 2.0) - Part 1

One of my colleagues, Kamil Sykora, compiled a document that goes through how to troubleshoot leaked SqlConnection objects (from a .NET 2.0 perspective).  It was a fairly large document, so I’m not going to post the whole thing.  I’m
Posted by psssql | 3 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
Tuesday, January 13, 2009 1:30 PM

"Error: SharePoint is installed but not configured" when installing the RS Add-in on Windows 2008

I ran across an interesting issue when trying to install the Reporting Services Add-in for SharePoint on a Windows 2008 server.  We would get the error listed above when trying to install the Add-in.  We choose repair on the Add-in component. 
Posted by psssql | 0 Comments
Wednesday, December 31, 2008 3:30 PM

SQL 2005 JDBC Driver and Database Mirroring

We ran into some interesting situations with the SQL 2005 JDBC Driver (v1.2) and it's use with failover partners. Take the following connection string: jdbc:sqlserver://myserver1;databaseName=AdventureWorks;failoverPartner=myserver2; In this connection
Posted by psssql | 2 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, November 18, 2008 11:57 PM

RSWindowsNegotiate and 401.1 Error when using RS 2008

While I was setting up one of my demos for SQL PASS, I starting hitting 401.1 errors.  I was setting up a SharePoint Intergrated setup with Reporting Services. I knew I had a distributed environment, so I accounted for my Kerberos configuration. 
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
 
Page view tracker