This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A small wooden drawer rests beside a larger matching drawer in a sunlit workshop.

Moving From Express to Standard Without Reinstalling

December 22, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Plan how to upgrade SQL Server edition from Express to Standard, preserve the instance, and verify databases and applications after setup.

Read More
SQL SERVER - Fix: Error - VS Shell Installation Has Failed with Exit Code 1638

SQL SERVER – Fix: Error – VS Shell Installation Has Failed with Exit Code 1638

December 21, 2017
Pinal Dave
SQL Tips and Tricks
SQL Download, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Installation

A customer’s SQL Server 2017 install kept failing with “VS Shell installation has failed with exit code 1638”. Here is what caused it and how we fixed it.

Read More
SQL SERVER - Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298

SQL SERVER – Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298

November 14, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Installation, Starting SQL, Windows

A SQL Server 2012 install failed with an error while enabling windows feature NetFx3. Here are the steps to turn on .NET Framework 3.5 in Server Manager.

Read More
Gouache painting of a small terracotta pot with a seedling, standing in a saucer on a wide bare grey stone slab, a vermilion ribbon tied around the pot

Setup Permission Setting Error: Updating Permission Setting for File Failed

November 11, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Installation, SQL TempDB

A setup permission setting error stopped a brand-new SQL Server 2016 install at the end. The cause was a TempDB location set to the root of a drive. A dedicated folder for TempDB fixed it.

Read More
SQL SERVER - Why Edition Upgrade is Not Upgrading Edition of SQL Server?

SQL SERVER – Why Edition Upgrade is Not Upgrading Edition of SQL Server?

July 17, 2017
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Installation, SQL Upgrade

A DBA friend ran Edition Upgrade from Standard to Enterprise, setup finished with no errors, yet SQL Server still showed Standard Edition. Here is why.

Read More
SQL SERVER - Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet

SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet

July 14, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Installation, SQL Server Management Studio, SQL Server Security

SQL Server setup warned on the Microsoft .NET Application Security rule because the computer cannot access the Internet. Here is what it means and what to do.

Read More
SQL SERVER - Installation Error - Status Code: 183 Description: Cannot Create a File When that File Already Exists

SQL SERVER – Installation Error – Status Code: 183 Description: Cannot Create a File When that File Already Exists

June 9, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Cluster, SQL Server Installation

SQL Server 2014 setup on a Windows 2012 cluster with mount points failed with Status Code 183: Cannot create a file when that file already exists.

Read More
Previous 1 2 3 4 5 6 7 8 … 12 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com