Questions tagged [installation]

Installation (or setup) of a database application, is the act of putting the application onto a computer system so that it can be executed.

Filter by
Sorted by
Tagged with
45 votes
4 answers
103k views

Can I install SQL Server Management Studio locally?

Can I install SQL Server Management Studio on my desktop to access a database on a SQL Server 2012 instance? If so, where can I find the installer? Google searches only return 'express' versions ...
pgunston's user avatar
  • 665
3 votes
3 answers
34k views

Where does my.cnf get stored in Linux?

I am new to linux, and i just installed MySQL-server-5.1.59-1.glibc23.i386.rpm in my linux machine. I wanted to know where my.cnf file gets stored..? Will my.cnf gets created with the installation ...
Phanindra's user avatar
  • 1,007
60 votes
2 answers
40k views

PostgreSQL EXCLUDE USING error: Data type integer has no default operator class

In PostgreSQL 9.2.3 I am trying to create this simplified table: CREATE TABLE test ( user_id INTEGER, startend TSTZRANGE, EXCLUDE USING gist (user_id WITH =, startend WITH &&) ); ...
Ian Timothy's user avatar
2 votes
3 answers
5k views

Problem getting SQL Server 2016 R Services (In-Database) working

SQL Server 2016 CU2 (Enterprise) here and one of my users has requested that we get R-Services installed. I followed what appeared to be very simple instructions from this page Set up SQL Server R ...
Scott Hodgin - Retired's user avatar
10 votes
3 answers
21k views

Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS

Background I am attempting to install Oracle 12c on CentOS 7 (deployed as a Hyper-V virtual machine) as outlined by this installation guide. Problem Everything with my installation goes well except ...
Dodzi Dzakuma's user avatar
5 votes
2 answers
754 views

Determining the Actual Server Create Date

I am interested in determining the ages of all 70+ my servers. I would like to create a growth graph showing when servers and databases were added to the environment either/both monthly or annually. I ...
Dave's user avatar
  • 81
4 votes
2 answers
3k views

DB2 Express-C on Mac OS X

I have followed all the steps described on the Getting Started with DB2 Express v9.7 e-book and installed DB2 Express-C on my Mac. The installation succeeded without a problem. I did setup OS X ...
ivanmp's user avatar
  • 2,323
16 votes
5 answers
78k views

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes [closed]

I try installing SQL2008R2 - SQL2012 - sql2014 2014-07-17 16:31:16.00 spid14s Error: 17190, Severity: 16, State: 1. 2014-07-17 16:31:16.00 spid14s Initializing the FallBack certificate failed ...
user43965's user avatar
  • 169
13 votes
1 answer
3k views

Why is it bad practice to install SQL Server to the root of a drive

When I install SQL Server into the root of my drive, for example D:\, I get an error when I run a database deployer from a third party piece of software. But when I move my SQL Server instance to D:\...
Sean's user avatar
  • 233
11 votes
1 answer
2k views

Determine the SQL Server version and edition from the available set up, before actually installing it?

We are going through a downgrade process from SQL Server 2008 R2 Enterprise to Standard edition. To kick off the above activity, we were looking for available Standard Edition of SQL Server. We found ...
KASQLDBA's user avatar
  • 7,159
7 votes
7 answers
27k views

Oracle 11g installation stuck at installation

I'm trying to install oracle 11g on fedora by following this tutorial but it stuck after I click Next in step 8. The screen does not go away even after several hours. There's no log file in ...
Uzair Farooq's user avatar
4 votes
2 answers
6k views

Failure during install of SQL Server 2016 sp2

I'm trying to install the new SP2 for SQL Server 2016, but it fails during the install with an Engine error. This is what I can read in the errorlog> Error: 468, Severity: 16, State: 9. Cannot ...
Henrik Staun Poulsen's user avatar
2 votes
1 answer
6k views

SQL Server 2005 collation issue during installation

Every time I try to install SQL Server 2005 on to a Windows 7 machine it installs properly but the collation installed is sql_latin1_general_as instead of sql_latin1_general_cp1_ci_as. I have read ...
Soham Dasgupta's user avatar
2 votes
2 answers
14k views

Downgrade SQL Server Enterprise Edition to SQL Server Standard Edition

There is a requirement in our project where they want to evaluate if it is possible to downgrade SQL Server from Enterprise to Standard edition and if a server can be decommissioned. How can I ...
KASQLDBA's user avatar
  • 7,159
2 votes
1 answer
10k views

Postgresql 11.5 installation problem

While installing PostgreSQL I keep getting the message: "Problem running post-install step. Installation may not complete correctly The database cluster initialisation failed." This seems to ...
Jesse's user avatar
  • 21
1 vote
3 answers
13k views

SQL Server 2017 Installation issues

When installing SQL Server 2017 on my computer/server I am receiving an installation error. Error Log Overall summary: Final result: Failed: see details below Exit code (Decimal)...
HaBo's user avatar
  • 191
1 vote
1 answer
1k views

How to copy all firewall rules and apply them on a new server?

I often install new SQL Server Servers. Be them production, test or development. There is one thing I still have not automated and it is time consuming: the firewall settings. I know how to ...
Marcello Miorelli's user avatar
172 votes
4 answers
178k views

Help installing SQL Server 2017 - VS Shell installation has failed with exit code 1638

Any suggestions on how to deal with this error: TITLE: Microsoft SQL Server 2017 Setup ------------------------------ The following error has occurred: VS Shell installation has failed with exit ...
Jonathan Allen's user avatar
114 votes
11 answers
360k views

How to run psql on Mac OS X?

I installed PostgreSQL on a computer with Mac OS X using the One click installer. Then I try to access PostgreSQL using the psql command, but it doesn't seem to be available. I get this message: ...
Jonas's user avatar
  • 33.1k
32 votes
1 answer
80k views

How to uninstall SQL Server Management Studio 2012?

How to uninstall SQL Server Management Studio 2012? ControlPanel's "Uninstall or change programs" (in Windows 7 Prof) gives a row of entries: while internet search results always tell: "click ...
Fulproof's user avatar
  • 1,382
28 votes
3 answers
92k views

Backup/Restore Users/Passwords/Privileges

I am moving from one server to another and I want to backup all databases + users/privileges/passwords from my MySQL Server. I found to backup a database using mysqldump, but I cannot figure out, how ...
Nidhoegger's user avatar
20 votes
2 answers
13k views

Is there a cool way of performing CU updates for SQL Server on hundreds of machines?

My company has grown from 50 SQL Servers to over 200 overnight in a merger acquisition. HELP! My questions are: How can I perform CU updates on this many servers and still have a life and keep my ...
Russ Starksen's user avatar
14 votes
1 answer
18k views

How do I totally remove SQL Server 2017 on Ubuntu?

The docs has instructions about how to remove SQL Server. However, this leaves certain packages behind. How can I remove all traces and uninstall SQL Server 2017?
Evan Carroll's user avatar
  • 63.2k
13 votes
3 answers
17k views

How to do a minor upgrade of PostgreSQL on Windows, e.g. 9.3.0 to 9.3.1?

What is the recommended way to perform a minor upgrade from PostgreSQL e.g. 9.3.0 to 9.3.1 using the Enterprise DB built windows installer? Should I uninstall first or just install over the existing ...
buzz3791's user avatar
  • 386
13 votes
2 answers
118k views

Installing SQL Server 2012 Express fails with error " Could not find the Database Engine startup handle."

I'm attempting to install SQL Server Express 2012 w/ SP1 x64 on Windows 7 SP1 x64. This machine has previously had SQL Server Express 2012 installed. This instance was upgraded to SQL Server 2012 ...
Jonathan Bailey's user avatar
12 votes
4 answers
11k views

Installing default MySQL Tables in Windows (mysql_install_db)

In Linux, the default MySQL grant tables can be created with the mysql_install_db script, but that does not work on Windows. How can the default grant tables be installed on Windows? (No, I’m not ...
Synetech's user avatar
  • 531
10 votes
2 answers
82k views

SQL Server 2000 on Windows 10

I need to install SQL Server MSDE 2000 SP4 on Windows 10. I have other machines that run Windows 7 and 8.1 and SQL Server MSDE 2000 works fine (with merge replication configured too). Now I testing ...
KronosInfo's user avatar
6 votes
2 answers
17k views

How to move from 32bit SQL Server install to 64bit?

A production server has accidentally been installed with SQL Server 2012 32bit version, while it needed a 64bit version. How best to fix this issue? Is it possible to simply UPGRADE from 32 to 64 ...
Greg Bala's user avatar
  • 1,015
6 votes
6 answers
30k views

Oracle 11g setup closes without errors on pre-requisite check

I'm installing Oracle 11g and the setup wizard just closes automatically after the pre-requisite check. I have administrative access UAC is disabled IPv6 is diabled There is more than enough free ...
Muhammad Hasan Khan's user avatar
6 votes
4 answers
5k views

SQL Server Management Studio SSMS 18.0 General Availability release (GA) install fails

Requirement I wish to install SSMS 18.0 GA (https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017), on Windows 10 but get error: Uninstall ...
Andy Jones's user avatar
  • 1,381
6 votes
3 answers
12k views

Not able to install any piece of SQL server 2012 dev edition on my windows 7

I have tried everything i can think f to install SQL 2012 but no luck I am getting these errors but after looking through the logs I can't find the actual cause to get a solution. every feature gives ...
greektreat's user avatar
5 votes
2 answers
42k views

Oracle program "lsnrctl" is missing after the installation of 32bit Oracle client

I cleaned up my computer for all old Oracle stuff using Uninstall (OUI) and then later used regedit to delete all references to Oracle and then deleted all remains of Oracle directories. I have HP ...
Osprey's user avatar
  • 51
5 votes
1 answer
26k views

How to configure SQL Server Port on multiple instances?

I have a server called SQLDWDEV01, with 2 instances: default and UAT. To the default instance that uses port 1433, everything works fine. However, the UAT instace, which I configured according to ...
Marcello Miorelli's user avatar
5 votes
1 answer
8k views

Installing SQL Server, I get unmet dependencies libc++1 and libjemalloc1 but it is not installable

Here is the output, $ sudo apt install -y mssql-server Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may ...
Evan Carroll's user avatar
  • 63.2k
5 votes
2 answers
20k views

2 Different Oracle DB Version on same server

Is it possible to install and run 2 different oracle version(11g and 12c)software and db on same server? is it possible then how we can? and if not then why? Thanks Rahul Joshi
Rahul Joshi's user avatar
5 votes
5 answers
15k views

Install MariaDB without password prompt in Ubuntu

I need to install MariaDB server in Ubuntu without password prompt. For this purpose, I execute the following commands, but it doesn't gave me any progress. It again shows password prompt. I used the ...
Haseena's user avatar
  • 571
4 votes
1 answer
3k views

How to apply a patch in PostgreSQL on Windows?

How to apply a patch in PostgreSQL? I found an advice, but it seems to be suited for *NIX only. My PostgreSQL (9.3.1 EDIT: 9.3.4 now) was installed from an exe installer on Windows XP (32 bit), so I ...
Pavel V.'s user avatar
  • 747
4 votes
2 answers
60k views

How to uninstall SQL server 2012 not showing in control panel's "Programs and features"

I am frustrated to the core. While fixing my Sql Server I've made the situation worse. Here is the problem: initially my master database was corrupted, so the MSSql service was not starting. I tried ...
user avatar
4 votes
2 answers
46k views

How do I uninstall the old version of Postgres on CentOS 7?

I just installed Postgres 9.6 on CentOS 7. However when I run [root@server tmp]# /usr/bin/psql --version psql (PostgreSQL) 9.2.23 It still seems to be pointing to my old version. How do I ...
Dave's user avatar
  • 703
4 votes
1 answer
7k views

Installing SQL Server on not the default path

I am trying to install SQL Server 2012 on a machine which has 764 Mb Free Space on C: 832520 Mb Free Space on D: So during the installation process I changed the default location from C:\Program ...
mcha's user avatar
  • 163
3 votes
1 answer
4k views

PostgreSQL CREATE EXTENSION file not found error on Mac OS

On PostgreSQL 9.2.3 when trying this: CREATE EXTENSION btree_gist; I get this error: ERROR: could not open extension control file "/opt/local/share/postgresql92/extension/btree_gist.control": No ...
Ian Timothy's user avatar
3 votes
2 answers
1k views

Install PostgreSQL using source code or using apt-get?

I want to install PostgreSQL on a server that runs Ubuntu 14.04.2 LTS. I understand that I have two options: Install PostgreSQL using the source code distribution Install PostgreSQL using apt-get ...
dw8547's user avatar
  • 937
3 votes
1 answer
22k views

Is it possible to install SQL Server 2014 Enterprise on Windows 7?

I'm planning to install SQL Server 2014 Enterprise Edition on a 64-bit HP workstation. I read the software and hardware requirements on: https://msdn.microsoft.com/en-us/library/ms143506.aspx And ...
Daniel's user avatar
  • 33
2 votes
2 answers
15k views

Oracle 11gR2 Installation on Oracle linux 7 - Prerequisite condition failed for OS kernel parameter "semmni"

while Installing oracle 11gr2 on oracle Linux 7. The prerequisite condition to test whether the OS kernel parameter "semmni" is failed with below error. Please find the screenshot of it. Below is ...
azardin's user avatar
  • 55
2 votes
1 answer
551 views

SSAS and SQL Server on the same server

I have a server that is primarily used for SSAS, heavy processing, however I have SQL Server on it alongside SSAS, but I don't want sql server to hold ssas back. I have set the SQL Server MAX memory ...
Marcello Miorelli's user avatar
2 votes
2 answers
12k views

Access denied for user 'root'@'localhost' (using password yes)

I was trying to install MySQL 5.6.15 to my computer and got this error: unable to update security settings. access denied for user 'root'@'localhost' (using password yes) I guess current root ...
Ownur's user avatar
  • 21
2 votes
1 answer
49k views

Setup error :Attempted to perform an unauthorized operation [closed]

Below is the detailed error message. I can't proceed with installation for the last one week. I've given full rights to registry keys that are associated to SQL Server but nothing has worked out. For ...
Michael's user avatar
  • 29
2 votes
1 answer
1k views

SQL Server 2019: InitPersistentVersionStore failed after installing CU2

I have installed SQL Server 2019 CU 2 over a vanilla install of SQL Server 2019 RTM. Now I am puzzled by the following messages in the error log at startup: RecoveryUnit::...
Martin Guth's user avatar
2 votes
3 answers
32k views

Browse for Servers does not display local instance

I just installed SQL Server and SQL Server Management Studio but it doesn't show anything in servers list and I don't know how to connect to it. This shows that I have installed SQL Server: But ...
Waleed's user avatar
  • 141
1 vote
0 answers
244 views

problem installing mytop , need a up to date tools for monitoring mysql

so i'm trying to installl mytop to monitor the database i'm following this instruction : http://www.sohailriaz.com/how-to-install-mytop-a-top-clone-for-mysql/ when i try to install it with yum i get ...
max's user avatar
  • 145