Skip to main content
Share Your Experience: Take the 2024 Developer Survey
327 votes
Accepted

Help installing SQL Server 2017 - VS Shell installation has failed with exit code 1638

I experienced this problem as well with SQL Server 2017 Developer and it appears to be just bad planning on the part of the SQL Server installation package people. The problem is that Visual Studio ...
MapLion's user avatar
  • 3,456
78 votes
Accepted

How to install the additional module pg_trgm

pg_trgm is an extension, so: CREATE EXTENSION pg_trgm; If you get the following error ERROR: could not open extension control file ".../extension/pg_trgm.control": No such file or ...
Jendrusk's user avatar
  • 906
66 votes
Accepted

How to run psql on Mac OS X?

Appears "the way" to install the client, if you want to use hombrew, is: brew install postgresql@15 (you need to specify the version after @) then psql (the client command line) will now be ...
rogerdpack's user avatar
  • 1,274
34 votes
Accepted

Where to download SQL Server 2019 Express LocalDB Installer MSI from

The documentation page containing download links for LocalDB 2016 onward is: SQL Server Express LocalDB - Installation media Direct download links are not officially supported. The following LocalDB ...
Ivan Zlatanov's user avatar
24 votes
Accepted

How do I totally remove SQL Server 2017 on Ubuntu?

These are actually very poor instructions on how to remove the Microsoft SQL Server. SQL Server installs these associated packages. mssql-server mssql-server-fts mssql-tools msodbcsql unixodbc-dev ...
Evan Carroll's user avatar
  • 63.5k
18 votes

How to run psql on Mac OS X?

Install just client with brew: brew install pgcli then link it: brew link --force libpq as output you will get the path to psql: If you need to have this software first in your PATH instead ...
Iurii Perevertailo's user avatar
15 votes

How to install the additional module pg_trgm

1) Log into postgres psql -U <DB_USERNAME> 2) After you are connected, switch to the DB you want to install the extension for: \c <DB_NAME> 3) Then install the extension as answered ...
Troy Porter's user avatar
14 votes

Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS

I encountered this exact error and found it was my mistake. Spent whole day for that. Please, carefully observe your /etc/hostname and /etc/hosts. In my case, "oem" was put in /etc/hosts and "eom" ...
munkhbayar batkhuu's user avatar
13 votes
Accepted

psql: FATAL: role "postgres" does not exist

Not a full answer, but consider the manual about initdb here: -Uusername --username=username Selects the user name of the database superuser. This defaults to the name of the effective user ...
Erwin Brandstetter's user avatar
12 votes
Accepted

MySQL fails to start on arch Linux. Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

The arch wiki helped me solve this pretty quickly. Install mariadb, afterwards run the following command before starting the mariadb.service: mysql_install_db --user=mysql --basedir=/usr --...
nelaaro's user avatar
  • 727
12 votes
Accepted

How can I install the SQL Server PowerShell module on an offline machine?

PowerShell has a built-in mechanism for this which should be easier than the previous answer. From an Internet-connected computer, run Save-Module sqlserver -path c:\tmp (substitute whatever path you ...
alroc's user avatar
  • 1,684
11 votes

Help installing SQL Server 2017 - VS Shell installation has failed with exit code 1638

I had the same problem but I was upgrading from SQL Server 2016. I uninstalled Microsoft Visual C++ 2015 Redistributable, both the x86 & x64, then it upgraded successfully.
glowworms's user avatar
  • 211
11 votes
Accepted

Install SQL Server on Debian

This worked for me on Debian 8 (Jessie) when I installed the pre-2017 vNext for dbfiddle: apt-get install curl apt-transport-https sudo add deb http://ftp.debian.org/debian jessie-backports main to /...
Jack Douglas's user avatar
10 votes
Accepted

Windows Server 2012 R2 Essentials and SQL Server 2014

I would ask your vendor why they can't install SQL Server on a domain controller because the documentation seems to indicate otherwise. See the Installing SQL Server on a Domain Controller section of ...
Tom V's user avatar
  • 15.7k
9 votes
Accepted

What is AzureAttestService?

This service has to do with the Always Encrypted with Enclaves feature. I have sent a note to the team to get this more explicitly documented for customers. Some scenarios will break if that service ...
Conor Cunningham MSFT's user avatar
7 votes

configure: error: SQLite3 library not found

I tried both, sudo apt-get install sqlite and building from source but problem persists. Then I tried the following command and it worked. May be it'll help someone else too. sudo apt-get install ...
MD Ruhul Amin's user avatar
7 votes

Can't install Microsoft SQL Server 2016 Release Candidate 3 (RC3) on Windows Server 2008 R2

I found the answer here: Warning Setup Limited to Reporting Services for SharePoint by Alberto Morillo Which, in short, says: The only SQL Server 2016 features allowed to install on Windows Server ...
user2109254's user avatar
7 votes
Accepted

installing SQL SERVER 2016 side-by-side SQL Server 2012

Installing SQL Server 2016 side by side with an existing SQL Server 2012 can (usually) be installed without issues and is supported as they state in that article. SQL Server supports multiple ...
Tom V's user avatar
  • 15.7k
7 votes

Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS

You might want to try adding your host to /etc/hosts. I encountered the same error and the problem went away after I've done so. See Install Oracle Database 12c On CentOS7 by M.el Khamlichi. ...
Steven's user avatar
  • 71
7 votes
Accepted

Installing SQL Server, I get unmet dependencies libc++1 and libjemalloc1 but it is not installable

This is because both of those packages are in the Ubuntu Universe, to enable that repository you can use, sudo add-apt-repository "deb http://archive.ubuntu.com/ubuntu $(lsb_release -sc) universe" ...
Evan Carroll's user avatar
  • 63.5k
7 votes
Accepted

how to list all features installed in a sql server instance?

You can run "Installed SQL Server features discovery report" It is documented there: Validate a SQL Server Installation Some examples: how-to-find-out-what-sql-features-are-installed
Piotr Palka's user avatar
  • 1,591
7 votes

MySQL - "Visual Studio must be installed" - but it is?

I had this issue, and it turned out to be because I didn't have the .NET workload installed in Visual Studio. You need to either select it on installation, or re-run the installer, select 'modify', ...
Olaf Davis's user avatar
7 votes
Accepted

Differences between MariaDB docker tags

Short answer: Nothing. Long answer: "Latest" refers to be the latest, which is 10.5.y; some day soon it may refer to the latest 10.6.y, which is is early stages of being released. 10 refers ...
Rick James's user avatar
  • 78.4k
6 votes

Error: Unable to write inside TEMP environment variable path

Go to: Regedit => HKEY_CURRENT_USER => Software => Microsoft => Windows Script Host => Settings => Enabled Double Click in Enabled. Change ...
hailush's user avatar
  • 61
6 votes

How to resolve "the specified account already exists" error during SQL Server 2008 R2 installation

Regarding where is the indication that SQL Native Client is the issue – the error actually occurs while trying to install the newer SQL Native Client. The solution seems to be: go to Add/Remove ...
shivesh suman's user avatar
6 votes

Should I install SQL Server 2012 SP3 when I'm already running SQL Server 2014?

Windows Update isn't offering you a Service Pack for SQL Server 2012 to apply to your SQL Server 2014 instance; there is something else on your machine that is triggering it. Could be dozens of things,...
Aaron Bertrand's user avatar
6 votes
Accepted

SQL Server 2016 support for 32-bit systems

These fixes aren't for the database engine. Why are there both x64 and x86 packages? As above, while there is no x86 engine, fixes can apply to a variety of shared components on the machine (...
Aaron Bertrand's user avatar
6 votes

Install SQL Server on Debian

Yes, there is a chance the installation will succeed, or that you can work around any issues. It wouldn't be a supported configuration, but it might work. You also can try the docker image.
David Browne - Microsoft's user avatar
6 votes
Accepted

Is .NET Framework 3.5 still needed with a SQL Server 2017 installation to utilize Database Mail?

No, it is not required for SQL Server 2017. The issue with Database Mail not working was fixed in 2016 SP1 CU2, and 2016 RTM CU2: FIX: SQL Server 2016 Database Mail does not work on a computer that ...
Tony Hinkle's user avatar
  • 7,954
6 votes

SQL Server Management Studio SSMS 18.0 General Availability release (GA) install fails

From the command line, I was able to uninstall a different 18.0 preview (I don't have 6 anywhere): msiexec /x "{2051D5D4-618D-4B9F-BA64-C1AE19003F2E}" But I did not have the error about the shell ...
Aaron Bertrand's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible