SQL Server 2017 – VS Shell Installation Has Failed with Exit Code 1638

You may receive the following error while installing SQL Server 2017 or upgrading your SQL server from the previous version: Microsoft SQL Server 2017 Setup The following error has occurred: VS Shell installation has failed with exit code 1638. For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=14.0.1000.169&EvtType=0x5B39C8B9%25401434%25403 Solution This issue is caused by Microsoft Visual C++ 2017 Redistributable (x86) […]

Microsoft SQL server internal database version

While perform some task on Microsoft SQL server, you may see the different version number in the error message as follow: The database ‘WHDdb’ cannot be opened because it is version 852. This server supports version 782 and earlier. A downgrade path is not supported. In this article we will list the internal database version […]

Could not load file or assembly ‘Microsoft.SqlServer.Diagnostics.STrace’

You may receive the following error while starting SQL server 2008 Management Studio: The type initializer for ‘Microsoft.SqlServer.Management.Dmf.PolicyStore’ threw an exception. (Microsoft.SqlServer.Dmf) Could not load file or assembly ‘Microsoft.SqlServer.Diagnostics.STrace, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified. In most cases, uninstalling Visual studio and .Net 4 and reinstalling […]