306
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 ...
28
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 ...
25
You will select "Microsoft SQL Server 2012 (64-bit)"
Upon loading of the setup wizard, you will select the instance for SQL Server 2012. The next screen you check the shared component you want to remove.
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 ...
21
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-...
21
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 ...
19
PostgreSQL 9.1+
Note that I'm working on Ubuntu 12.04, which uses postgresql 9.1.
There, I needed to:
sudo apt-get install postgresql-contrib
And then in my database:
postgres@ztrustee:~$ psql test
psql (9.1.3)
Type "help" for help.
test=# CREATE EXTENSION pgcrypto;
CREATE EXTENSION
And now I can use pgcrypto functionality, gen_random_bytes():
test=# ...
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 ...
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
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 ...
15
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 ...
14
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
The cool way is to use an unattended installation script that simply is called from each server, where the media for the installation is on a central directory on your network, that is accessible from each server. You will have to run the script in an elevated mode, which this is fairly easy in PowerShell.
You will need to use the CLI to extract the hotfix, ...
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
...
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 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
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'
10
If the correct auditing is turned on, and the security event log hasn't rolled over it'll be in there. Failing that it may not be.
You could look at NTFS file permissions and ownership, and what accounts have sysadmin rights and possibly figure it out.
10
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" ...
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
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
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 ...
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 ...
10
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 ...
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
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....
9
Integration Services is not "Instance aware". The rest (Analysis, Reporting, DB) are.
Note that SSIS doesn't need to be instance aware either. The service itself is pretty pointless and doesn't need to running. You simply need the SQL Server common binaries installed to run packages. The service is for SQL Server Agent and SSMS to browse packages etc
Links:...
9
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 ...
Only top voted, non community-wiki answers of a minimum length are eligible
