327
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 ...
answered Aug 13 '14 at 16:31
Aaron Bertrand
170k2323 gold badges358358 silver badges565565 bronze badges
42
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-...
36
Install the additional module btree_gist as is mentioned in the manual at the location you linked to:
You can use the btree_gist extension to define exclusion constraints
on plain scalar data types, which can then be combined with range
exclusions for maximum flexibility. For example, after btree_gist is
installed, the following constraint will ...
answered Mar 22 '13 at 19:32
Erwin Brandstetter
127k1616 gold badges291291 silver badges432432 bronze badges
22
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 ...
answered May 22 '17 at 5:40
Evan Carroll
48.1k2424 gold badges159159 silver badges350350 bronze badges
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 ...
answered Aug 24 '15 at 15:51
Aaron Bertrand
170k2323 gold badges358358 silver badges565565 bronze badges
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 ...
answered Nov 15 '15 at 20:21
Solomon Rutzky
61.3k66 gold badges124124 silver badges248248 bronze badges
19
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 psql to make it more "user friendly" ...
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 ...
17
You can simply install a new, named instance, and the two instances can live side-by-side with no risk - just be sure that your connections strings etc. are clear and correct (many problems arise from connecting to LOCALHOST when you meant to connect to LOCALHOST\OtherInstance).
Depending on resources you may want to be sure to cap both servers using the ...
answered Jun 5 '13 at 12:32
Aaron Bertrand
170k2323 gold badges358358 silver badges565565 bronze badges
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 ...
16
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-...
16
If somebody stumbles upon this, here is the full download URL for SQL Server 2019 LocalDB
13
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
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 ...
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.
answered Aug 13 '14 at 2:55
Thomas Stringer
40.4k99 gold badges107107 silver badges151151 bronze badges
11
No, no and again no. One instance, one server, Always. The reasons have to do with the SQL Server memory manager and CPU scheduler architecture, it really works best if it has the whole box to itself and nothing else runs on the box. 'Partitioning' of resources (max server memory, affinity mask) solves some problems and introduces more.
If you want to ...
11
I see two things wrong here. Oracle tries to open a parameter file in the $ORACLE_HOME/dbs directory with the format "spfile" + $ORACLE_SID + ".ora". If it cannot find it, it then tries to open "init" + $ORACLE_SID + ".ora". This is where the problem(s) are.
By virtue of the fact that Oracle is trying to open a parameter file named "initXE.ora", your SID ...
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 ...
answered Sep 11 '15 at 16:50
Aaron Bertrand
170k2323 gold badges358358 silver badges565565 bronze badges
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'
answered Sep 17 '15 at 17:07
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 ...
answered Jan 31 '16 at 17:54
Aaron Bertrand
170k2323 gold badges358358 silver badges565565 bronze badges
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
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....
answered Feb 17 '18 at 14:57
Jack Douglas
35.1k1313 gold badges8989 silver badges169169 bronze badges
10
Two solutions:
Install Oracle manually the first time. Then zip all ORACLE_HOME and for future installation simply:
Unzip oracle_home into the new home
Run $ORACLE_HOME/bin/relink all
Run ./runInstaller -silent -attachHome ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Oracle_Home_Name>"
SID is a property of the database/instance and ...
10
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....
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 ...
Only top voted, non community-wiki answers of a minimum length are eligible
Related Tags
installation × 590sql-server × 234
oracle × 124
mysql × 62
sql-server-2012 × 61
postgresql × 55
sql-server-2008-r2 × 40
linux × 39
sql-server-2014 × 38
oracle-11g-r2 × 36
oracle-12c × 36
sql-server-2016 × 27
windows × 26
sql-server-2017 × 24
ubuntu × 20
configuration × 19
sql-server-2008 × 18
ssms × 16
oracle-11g × 16
upgrade × 12
mac-os-x × 12
mongodb × 11
clustering × 11
mariadb × 10
mysql-5.5 × 10