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 ...
- 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 ...
- 176k
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"
...
- 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 ...
- 844
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 ...
- 396
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
...
- 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 ...
- 176k
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 ...
- 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 ...
- 65.8k
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 ...
- 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 ...
- 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 ...
- 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" ...
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 ...
- 41.4k
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 ...
- 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 ...
- 221
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 ...
- 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 ...
- 176k
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 ...
- 176k
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 --...
- 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.
- 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 /...
- 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 ...
- 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 ...
- 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 ...
- 101
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 ...
- 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 ...
- 152k
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 ...
- 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 ...
Only top scored, non community-wiki answers of a minimum length are eligible