325
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 ...
34
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-...
32
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
118k16 gold badges265 silver badges406 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 ...
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 ...
18
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 ...
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 ...
17
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 ...
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-...
13
I had a similar isssue - Win7SP1, VS2010SP1, SQL2008R2, Powershell 2 etc. Every prerequisite was there and still SQL Server 2012 Developers edition did not install. Completing with the following error message for most of the features:
Feature: Database Engine Services
Status: Failed: see logs for details
...
13
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" ...
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
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.
12
If somebody stumbles upon this, here is the full download URL for SQL Server 2019 LocalDB
11
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 ...
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
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
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
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 says try topanswers.xyz
34.4k13 gold badges88 silver badges163 bronze badges
10
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 ...
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 ...
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 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 .....
10
If you already have SQL Server 2014 RTM installed
You can't do any slipstreaming - service packs don't support that, only initial installs.
(please vote! ----------------------^^)
You can't apply an SP1 CU without first applying SP1.
Cumulative updates are cumulative - if you eventually want to get to SP1 CU2, you can ignore SP1 CU1 altogether.
So, in ...
Only top voted, non community-wiki answers of a minimum length are eligible
