330
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 2017 installs the Microsoft Visual C++ 2017 Redistributable (x86) and (x64) and the SQL Server installation tries to install the Microsoft Visual C++ 2015 ...
75
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 the components you need), as well as a release cycle completely independent from SQL Server, go here (and you can read about it here and here).
If you use ...
53
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"
then you need to install the module for your operating system
Ubuntu/Debian:
sudo apt install postgresql-contrib
Redhat/Centos
sudo dnf install postgresql10-...
27
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 download links were copied from Scott Hanselman's blog post:
SQL Server 2016 SP1: https://download.microsoft.com/download/9/0/7/907AD35F-9F9C-43A5-9789-...
25
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 Postgres server/database, but you don't have to use that if all you want is the client).
Apparently there's also a 'wrapper' to the psql command to make it more &...
23
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
Assuming you wish to totally remove SQL Server, you should
# Stop the service
systemctl stop mssql-server.service
sudo add-apt-repository --remove "$(curl ...
21
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 the host system) and within the operating system (which prevents many flavors of older software from getting installed, mostly for security reasons but also ...
20
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 root -p mysql user > user_table_dump.sql
These mysql database tables contain grant information
user: User accounts, global privileges, and other non-...
20
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 running until manually shut-down.
LocalDB is user-mode background process. It starts either when the first request to connect comes in (assuming the request is ...
18
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 specific folders. As per this connect item
Based on further investigation this issue is due to the fact that SQL tightens the ACL for default data/log ...
16
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 online. Either is lacks privilege or it is corrupted. During installation of database engine services SQL Server tries to bring online database services as a ...
14
I strongly recommend using Postgres.app from the Heroku team, which is also supported by them!
It has a menubar icon and the menu has a psql item:
You will also find psql included here if you want the same version of that as the server (path may vary by version):
/Applications/Postgres.app/Contents/MacOS/bin
If you want, you can add this path to your ...
14
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" was in /etc/hostname.
12
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 to various SQL-Server Express versions.
By the way, you can also use the latest SSMS 2014 to manage your 2012 database.
11
I was having this issue on Windows 7 64-bit and the following solution is what worked for me (via http://igordcard.blogspot.com/2012/03/unable-to-write-inside-temp-environment.html):
Why
To understand why this error was happening, I went to my TEMP folder and read the log from the PostgreSQL installer: C:\Users\myuser\AppData\Local\Temp\bitrock_installer....
11
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 place):
Microsoft SQL Server\80\Tools\Binn
Microsoft SQL Server\MSSQL\Binn
Find out sqlunirl.dll on SP4 path and copy to Binn folder above
Copy dll files on .....
11
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 Directory, I'll give full control to the SQL Server Process account.
Related official documentation:
Configure File System Permissions for Database Engine ...
11
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 above as it was never migrated to the newer "Feedback" system; the link merely takes you to an archived version of the request that used to exist)
You ...
11
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 Upgrade Rules
Even more information at:
SQL 2012 Setup Rules – The 'Missing Reference'
11
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 options you selected during setup, but from the programs applet, it seems like you should have at least one instance installed.
The Browse for Servers dialog is ...
11
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 --datadir=/var/lib/mysql
mysql_secure_installation
Arch does not hold your hand, with this type of thing.
I guess if you install mysql / mariadb from source this is ...
11
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.
11
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 /etc/apt/sources.list
apt-get update && apt-get install -t jessie-backports openssl ca-certificates
curl https://packages.microsoft.com/keys/microsoft....
10
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 window ( during installation) is somehow not able to bring SQL Server database engine services online. Either is lacks privilege or it is corrupted. During ...
10
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 Hardware and Software Requirements for Installing SQL Server 2014
For security reasons, we recommend that you do not install SQL Server
2014 on a domain ...
10
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 want for the module to be saved to). This will save the module to a directory of the same name in c:\tmp (c:\tmp\SqlServer).
Then, copy that whole directory ...
9
Following up on my comment, you have to select ENU\x64\SQLEXPRADV_x64_ENU.exe for installation.
Download link.
Then run the installation package and follow instruction until you get feature selection page.
Follow rest of the steps and complete the installation.
Now Verify the RS installation :
Note: You must be logged in as a member of the local ...
9
From BOL:
During installation of SQL Server 2012, Windows Installer creates temporary files on the system drive. Before you run Setup to install or upgrade SQL Server, verify that you have at least 6.0 GB of available disk space on the system drive for these files. This requirement applies even if you install SQL Server components to a non-default drive.
...
Only top voted, non community-wiki answers of a minimum length are eligible