Installation of SQL Server 2017 failing with ‘VS Shell installation has failed with exit code 1638’

Dear all, Depending on which products were installed on the server beforehand, a SQL Server 2017 setup may fail with the following error : TITLE: Microsoft SQL Server 2017 Setup —————————— The following error has occurred: VS Shell installation has failed with exit code 1638. Note that it could happen even after SQL Server 2017…


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: The feature: “The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for…

2

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-07-24 05:52:09 Slp: Initializing…

0

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 start. You will see…

0

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 of…

0

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 providers…

4

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 owner of hotfix…

1

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, SQL…

1