Browse by Tags

CSS SQL Server Engineers

This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services
  • Blog Post: SetFileIoOverlappedRange Can Lead to Unexpected Behavior for SQL Server 2008 R2 or SQL Server 2012 (Denali)

    You should be aware the Windows bug with API = SetFileIoOverlappedRange .   This is used by SQL Server (2008 R2 and SQL 2012) only when Locked Pages has been enabled and is in use by the SQL Server. SQL Server Support has NOT encountered this in a production environment.  The issue was found...
  • Blog Post: 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 SQL Server...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: "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.  It got to the point of removing backup files...
Page 1 of 1 (9 items)