330 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 ...
user avatar
  • 3,486
75 votes
Accepted

Can I install SQL Server Management Studio locally?

If you want the shiny new 2016 monthly releases of Management Studio, which include a handy check for updates mechanism, negates the need for a full setup program and download (since it only retrieves ...
user avatar
57 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 directory" ...
user avatar
  • 696
39 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 then psql (the client command line) will now be available to you (it also installs a local ...
user avatar
28 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 ...
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 ...
user avatar
  • 56.2k
22 votes
Accepted

SQL Server 2000 on Windows 10

I know of no hacks to get SQL Server 2000 to install on an existing Windows 10 installation. There are probably forces against you from both within the setup program (which looks for certain things on ...
user avatar
21 votes
Accepted

Backup/Restore Users/Passwords/Privileges

The 'mysql' database contains users/privileges/passwords. So take the dump of mysql database along with other databases mysqldump [options] --all-databases > all_databases_dump.sql mysqldump -u ...
user avatar
  • 710
20 votes
Accepted

How do I connect to localDB from SQL Server 2014 Express

SQL Server Express LocalDB (commonly referred to as just "LocalDB") is not a service-based application: it does not show up in "Services", nor does it start up when the machine starts or even stay ...
user avatar
18 votes
Accepted

Why is it bad practice to install SQL Server to the root of a drive

Yes SQl server installation is likely to fail if you are trying to install it on root of a drive which is never advisable and has security implications. Actually it is related to permission setting on ...
user avatar
  • 18.3k
16 votes

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes

Following can be reason for this error The account which user selected on Server Configuration page window ( during installation) is somehow not able to bring SQL Server database engine services ...
user avatar
  • 18.3k
14 votes
Accepted

SQL Server data folder access rights

Have you looked under Advanced Security Settings? The arrows point to the modifications I've often had to specifically apply when installing SQL Server on Windows 2012 R2. For the SQL Server Root ...
user avatar
  • 9,478
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" ...
user avatar
12 votes

Can I install SQL Server Management Studio locally?

You can download and install SQL Server Management Studio using the links provided in: Scott Hanselman's website There are links to various SSMS versions (2012, 2014, for x86, x64), as well as links ...
user avatar
12 votes

Is there a cool way of performing CU updates for SQL Server on hundreds of machines?

Unattended installation is the way to go - as @ShawnMelton mentioned. To deploy CU on 100's of servers, you can explore below options (test them, so you know what will work for you and your ...
user avatar
  • 61.2k
12 votes

SQL Server 2000 on Windows 10

I managed to install following these steps: Extract SP4 Copy ..SP4\x86\other\sqlredis.exe to ..\originalinstallpath\x86\other (this avoid mdac insall freezing) Create this folder structure (any ...
user avatar
12 votes
Accepted

Skip multiple rules during SQL Server installation

Yes, just separate the rules with a space, for example: /SkipRules=PerfMonCounterNotCorruptedCheck FacetPowerShellCheck While SkipRules is undocumented, the list of rules is documented at: Edition ...
user avatar
  • 70.9k
11 votes
Accepted

Service pack and cumulative update

If you already have SQL Server 2014 RTM installed You can't do any slipstreaming - service packs don't support that, only initial installs. (note: you cannot vote for the suggestion linked directly ...
user avatar
11 votes

Browse for Servers does not display local instance

Your title says you have an installation problem, but I don't think this is the case (it seems like you have installed SQL Server okay, you just can't find it). Of course I don't know exactly what ...
user avatar
11 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 --...
user avatar
  • 637
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.
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 /...
user avatar
  • 37.5k
10 votes

Installing SQL Server 2012 Express fails with error " Could not find the Database Engine startup handle."

A simple and complete solution to error ' Could not find database engine startup handle' in below link Reason for the error can be 1.The account which user selected on Server Configuration page ...
user avatar
  • 18.3k
10 votes

Missing "MSVCR120.dll" during the Installation of MySQL Workbench 6.3 CE

I am getting the same error and I installed using MSI. Downloaded the VC redist packages for x64 and it fixed the issue: Visual C++ Redistributable Packages for Visual Studio 2013 Strange that the ...
user avatar
  • 101
10 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 ...
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 ...
user avatar
  • 15.4k
10 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 ...
user avatar
10 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 ...
user avatar
  • 1,579
9 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 ...
user avatar

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