How It Works: Timer Outputs in SQL Server 2008 R2 - Invariant TSC

  I would love nothing more than to take you back to my high-school days running the 440 yard hurdles (yes yards not meters) where timing was done with a stop watch (you know the old, moving dial style) but timers on the PC don’t allow that simplicity. I have discussed the timing behavior is…

4

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 gone through everything we normally go through and wasn’t getting anywhere. The situation was…

1

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 2005 installed and upgraded to Windows 2008 you would encounter the following errors when…

1

SQL, Powershell, Windows, Oh My!

I was in the process of setting up a repro for another Blog I’m going to be posting and ran into an unexpected situation.  My VM was running Windows 2003 and I had installed SQL 2008.  I was then going to upgrade to Windows 2008 Server and came across the following message: When you install…

1

The 3 Things you Need to Know to Install SQL 2005 on Windows 2008 Cluster

Today I was walking a counterpart through installing SQL Server 2005 cluster on a Windows Server 2008 cluster and realized there are three specific key things you need to know when installing SQL 2005 on Windows 2008 cluster.  I also saw that it was very helpful to have a few screen shots to quickly familiarize…

3

Updated Errors may occur after configuring Analysis Services to use Kerberos authentication on Advanced Encryption Standard Aware Operating Systems

The Microsoft SQL Server Analysis Services support team has seen an increasing number of issues involving errors when attempting to execute queries against or deploy databases to instances of Analysis Services 2005 and Analysis Services 2008 that are configured for Kerberos authentication and running on Windows 2008 Server or Windows Vista. This note provides information…

7

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 associated with it. Switches: -R = reset HOST ServicePrincipalName   Usage:   setspn…

3