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: RS: Database Engine does not meet edition requirements

    I've ran across the following error a few times and thought I would post this out there for people to understand what is happening. ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: , Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException...
  • Blog Post: SocketException when upgrading Reporting Services from SQL 2008/R2 to SQL 2012

    I ran into an interesting case yesterday that brought back some memories.  The customer had a SQL 2008 R2 instance of Reporting Services that they were upgrading to SQL 2012.  They didn’t get far into the upgrade when they hit the following error which was present in the Setup Logs: (16) 2012...
  • Blog Post: SQL Server 2008 R2 does not start when applying certain hotfix updates

    We have noticed that when you install certain hotfixes (this includes Cumulative Update 1 and certain versions of security update MS11-049 etc. ) on an SQL Server 2008 R2 RTM Instance on which Utility Control Point is configured, the installer fails to apply the upgrade scripts and SQL Server does not...
  • Blog Post: Where did the SQL Server Instance disappear? The clue may be in the WMI logs!

    We recently worked with a customer who ran into an interesting situation. This problem deals with SQL Server 2005 Service Pack 3 setup. Normally, when you launch the SQL 2005 SP3 setup and you reach the screen which shows the components for which you can apply the service pack, you will get a list...
  • Blog Post: SQL Server 2005 Cumulative Update or GDR fails when trying to rename the mssqlsystemresource files

    I’ve seen a few customers run in to this recently when the resource database is in a different location than the master database.  A cumulate update or GDR for SQL Server 2005 may fail with the following for the SQL Server Database Services 2005 in the Summary_%.txt log file.  Look for the...
  • Blog Post: Should I have a SNAC with my cumulative update?

    Here is a question we have received from several customers and internally at Microsoft: Do I need to apply the “SNAC” package that comes with some of the cumulative updates? Just so we are all on the same terms, SNAC refers to SQL Native Client . and basically contains our SQL Server “native code” data...
  • Blog Post: The Future of SQL Server Express Installation and Voting with Microsoft Connect

    The SQL Product team that owns setup is looking to improve the SQL Express installation experience including application developers who look to embed SQL Server Express with the install of their application. Peter Saddow is a Program Manager on this team and he and I go way back (Peter was the primary...
  • Blog Post: SQL Server Cumulative Update or Service Pack Fails With - CREATE DATABASE failed

    Here is a situation where a cumulative update patch can fail if the default database path for the data and/or log either does not exist, or there is a permissions issue.  This example is based on a SQL Server 2005 Cumulative Update 4 for SP3.  The problem can happen for any SQL Server 2000...
  • Blog Post: SQL Server Setup prompts with “The installed product does not match the installation source(s).” (Part I)

    Recently I looked at an issue when upgrading from SQL Server 2005 to SQL Server 2008 and in the middle of the upgrade it would halt asking for a matching source for VSS Writer.  However, there is nothing descriptive to tell you what specific source it is that you need to choose to find the right...
  • Blog Post: How To Test Drive SQL Server Clustering For Free

    I imagine that many of you are like me when it comes to purchasing software.   I want to take a test drive (evaluate) it before I buy it to make sure it really meets my needs.   You don't make a automobile purchase by just reading reviews you take it for a test drive.  Last week...
  • Blog Post: Installing .NET 3.5 Framework for SQL Server 2008 on a Windows 7 / Windows 2008 RC2 Builds

    The SQL Server 2008 install requires the .NET 3.5 framework.   Changes in Windows 7 can prevent SQL Server 2008 from installing the .NET 3.5 framework pre-requisite.   Instead you may need to install the framework separately. In Windows 7, the .NET Framework 3.5 is included as a Windows...
  • Blog Post: SQL Server 2005 Setup Failure (Multi-Core, Tri-Core, …)

    SQL Server 2005 has a startup check that fails on some of the newer CPU socket designs (triple core, tri core, 12 core, …) as outlined in the knowledge base article: http://support.microsoft.com/kb/954835 Continued testing shows that the NUMPROCS workaround documented in the article does not work for...
  • Blog Post: SQL Server 2008 SP1 and Cumulative Updates Explained.....

    NOTE: I've made a change to this blog post to account for the fact that actually 6 fixes in CU4 for 2008 RTM fixes DID made it into 2008 SP1. One of our readers sent me the following questions I think you will find valuable when understanding our recently posted SQL Server 2008 Service Pack 1 and our...
  • 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: SQLDumper unable to generate mdmp files in SQL Server 2008 Failover clusters

    SQLDumper utility is used by various components of the product to generate and save diagnostic information in the form of mini-dump and other log files. You will normally find the output files [with extension .mdmp, .txt and .log] created by sqldumper.exe in the LOG folder of the specific instance for...
  • Blog Post: How to fix your SQL Server 2008 Setup before you run setup (Part II)....

    NOTE: Now updated for SQL Server 2008 SP1 RTM. Last year you might have read my post where I showed you how to patch setup for RTM for SQL Server 2008 before you launch setup . This processing involved installing a Cumulative Update to apply fixes for the SQL Server 2008 Setup Support Files. Well, we...
  • Blog Post: SQL Server 2005 and 2008 Setup Failures (Compressed DATA Directory)

    We are always looking at customer issue reports in order to improve our software and your experience.   The SQL Server Setup development team has identified numerous Watson reports of failed setups due to the compression state of the DATA directory. Shown below is a failure I reproduced on...
  • Blog Post: Installing SQL Server 2005 SP3 or SQL Server 2008 on builds prior to XP SP3 Can lead to Bug Check (0xF4, Blue screen, Critical Process Termination)

    Due to a bug in Windows XP builds prior to the XP SP2 hot fix or XP SP3 release you may encounter one of the following bugs while attempting to install SQL Server 2008 or SQL Server 2005 SP3 based builds. An application that uses the Sxs.dll file crashes when you run the application on a Windows XP-based...
  • Blog Post: How to fix your SQL Server 2008 Setup before you run setup...

    Huh? This is not meant to be a brain teaser. The purpose of this post is to help you avoid problems with SQL Server 2008 setup before you run..well setup. Why not take advantage of known fixes we have for setup to avoid the problem in the first place? This would include a new installation, upgrade, or...
  • Blog Post: Welcome to SQL Server 2008 Patching

    We have posted the first cumulative update for SQL Server 2008 aptly named Cumulative Update 1 (CU1). I thought before you considered installing a patch for SQL Server 2008, you would like to see a tour of what it looks like compared to SQL Server 2005 patch installations. The first thing I did was download...
  • Blog Post: Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account

    UPDATE TO THIS POST: We now have a fix for this problem as documented at 968829 FIX: Error message when you try to upgrade an instance of SQL Server 2005 to SQL Server 2008: "Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes" http://support...
  • Blog Post: SQL Server 2005 Setup Fails in WOW (x86) On Computer With More Than 32 CPUs

      SCENARIO SQL Server fails to install a WOW64 instance (x86) an on a computer with more than 32 CPUs.    During setup you will encounter a SQL Server failed to start message.      SQL Server is attempting to determine the NUMA configuration during startup.   ...
  • Blog Post: SQL Server 2008 Management Tools Basic vs Complete Explained....

    A few questions have come up about the differences between the features you can install on SQL Server 2008 called Management Tools - Basic   and Management Tools - Complete. So I thought I'd blog about these to resolve any questions you might have. Related to this are questions I've received on...
  • Blog Post: How to Rebuild System Databases in SQL Server 2008

    In SQL Server 2005, we introduced a different method than in previous versions to rebuild system databases (affectionately known as "rebuild master"). You were required to use the setup.exe program with command line switches. This is no different in SQL Server 2008 but the command line switches...
  • Blog Post: SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1 explained...

    Many of you may have read my post about dependencies with Visual Studio 2008 SP1 and the .Net Framework 3.5 SP1 and SQL Server 2008. I have some related information to provide to you about SQL Server 2008 Express. If you are a user of SQL Server 2008 Express, there is some new information you should...
Page 1 of 2 (29 items) 12