Skip to main content

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
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
361k 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
64 votes
3 answers
90k views

How to install the additional module pg_trgm

I just want to know how to install the module pg_tgrm as used in the trigram indexing scheme that allows you to do un-anchored search patterns on an index. WHERE foo LIKE '%bar%';
Lizardie's user avatar
  • 773
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
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
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
24 votes
3 answers
59k views

How do I install pgcrypto in PostgreSQL 8.4?

I'm using Ubuntu Server 10.10 and I have installed PostgreSQL 8.4 using apt-get install postgresql. I would like to use the built-in sha1() function, but it seems that I have to install pgcrypto first....
Jonas's user avatar
  • 33.1k
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
18 votes
6 answers
62k views

How to resolve "the specified account already exists" error during SQL Server 2008 R2 installation

I recently had a problem while installing Visual Studio 2012 and SQL Server 2008 R2 on a new development machine. My installation sequence was Visual Studio 2012 then install SQL Server 2008 R2. An ...
RAY's user avatar
  • 403
16 votes
3 answers
33k views

Where to download SQL Server 2019 Express LocalDB Installer MSI from

SQL Server 2019 is released but I there doesn't appear to be a LocalDB version available for download. Does anyone know if there will be a LocalDB release or if 2017 is the last version?
Simon's user avatar
  • 263
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
16 votes
1 answer
10k views

What is AzureAttestService?

We started the installation and configuration of SQL Server 2019 on Windows 2019 and noticed after install a new service named 'AzureAttestService' was running and set to automatic. Services list the ...
SQLDBAND's user avatar
  • 355
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
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
13 votes
1 answer
62k views

SQL Server data folder access rights

I did a fresh SQL Server 2014 install. Next, I wanted to attach some databases from a previous SQL Server 2012 server. I copied all mdf and ldf files to the data directory, but when I tried to attach ...
tombom's user avatar
  • 3,158
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
12 votes
2 answers
23k views

SQL Server Network Configuration node missing from Configuration Manager after install

I have a server running Windows 2012 R2 Datacenter 64-bit. I was using SQL 2016 RC3 with no issues and I want to replace it with the RTM build we have from MSDN. After uninstalling RC3 and then ...
GregDBA's user avatar
  • 303
12 votes
2 answers
374k views

How to resolve ORA-01031: insufficient privileges error on Windows installation?

I installed Oracle 11G on my Windows 2008 R2 Server. I also installed Oracle Client Libraries using separate installation media. After the client installation, when I try to log into the database ...
jrara's user avatar
  • 5,333
11 votes
8 answers
160k views

Oracle startup error (could not open parameter file)

I installed the Oracle 11g server on Ubuntu 12.10. But I can't start the server. When I start up the server, the following error occurs: SQL> startup ORA-01078: failure in processing system ...
Praneeth Pj's user avatar
11 votes
3 answers
108k views

psql: FATAL: role "postgres" does not exist

Running PostgreSQL server on Void Linux. After installing ran initdb as OS user 'postgres': [user@host]$ sudo -u postgres -i $ initdb -D '/var/lib/postgresql/data' Received output: creating ...
Jakov's user avatar
  • 213
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,169
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
10 votes
2 answers
48k views

Can I install SQL Server 2012 on a machine with 2008 R2 already?

I have been using SQL Server 2008 R2 for quite a while, and it is working great. Now I need to use SQL Server 2012. Will this effect my existing databases? How much risk is involved in installing SQL ...
Imran Qadir Baksh - Baloch'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
10 votes
1 answer
37k views

How do I connect to localDB from SQL Server 2014 Express

I downloaded both the LocalDB and Management Studio for MS SQL Server 2014 Express so that I can practice on my local machine. However, when I open Management Studio and try to browse to localDB to ...
J.S.Orris's user avatar
  • 203
10 votes
3 answers
59k views

Missing "MSVCR120.dll" during the Installation of MySQL Workbench 6.3 CE

When I install MySQL Workbench 6.3 into my Windows 8.1, I encounter the following System Error : I already tried to redownload and reinstall the program but this error dialog appears every time. How ...
Casper's user avatar
  • 201
10 votes
2 answers
3k views

How to specify SQL startup parameters in quiet installation via command line

I want to fix the identity gap bug in SQL Server 2012 via the -T272 startup parameter. How can I automate this after installation? I found no install parameter for startup parameters.
Mohsen Afshin's user avatar
10 votes
2 answers
2k views

Issues with MySQL installation

First of all, excuse the length, this post is very long, and needs some background, second; it has been hard for me discerning the signal from the noise, please bear if some of this is not relevant: ...
erasmortg's user avatar
  • 151
9 votes
3 answers
22k views

How can I install the SQL Server PowerShell module on an offline machine?

I have some SQL Server machines that cannot connect to any external sites. I have been using PowerShell more and more when managing databases, so I definitely need this module to be installed so ...
Marcello Miorelli's user avatar
9 votes
4 answers
69k views

Oracle 12c Installation in Windows 7 error INS-30131

I am trying to install Oracle 12c in a Windows 7 x64 computer and after a while I get this error: SEVERE: [FATAL] [INS-30131] Initial setup required for the execution of installer validations failed. ...
Yván Ecarri's user avatar
8 votes
3 answers
21k views

Install SQL Server on Debian

I want to install SQL Server on Linux. From MS site I read that Red Hat, SUSE, and Ubuntu are supported but I want to use it under Debian. Since Ubuntu is based on Debian, is there a chance to succeed ...
i486's user avatar
  • 225
8 votes
2 answers
29k views

Is it possible to install oracle 12c without X window system

I am looking at installing Oracle 12c on a new server but the system admins are insisting that all new Linux servers don't have a GUI installed and that any administrative tasks are performed from a ...
GrumpyMonkey's user avatar
8 votes
2 answers
13k views

Why does SQL Server Management Studio crash?

When I open SSMS I get this message: SSMS - SQL Server Management Studio has encountered a problem and needs to close. We are sorry for the inconvenience. What can I do? The issue persists after ...
Ahmed elroghay's user avatar
7 votes
2 answers
8k views

Installing Full Text Search to SQL Server 2008 R2

I installed sql server 2008 R2 Express successfully, then realised I need to get Full Text Search. So I downloaded the "Advanced Services Installation Package", but when I run it there is no option in ...
hofnarwillie's user avatar
7 votes
1 answer
2k views

Service pack and cumulative update

Currently these updates are available for SQL Server 2014: SQL Server 2014 SP1 CU2 SQL Server 2014 SP1 CU1 SQL Server 2014 SP1 If I want to do a slipstream install: Is it enough to download #1 only ...
Avi's user avatar
  • 265
7 votes
2 answers
39k views

SQL Server 2012 Express with Reporting Services

Everywhere I search for SQL Server 2012 Express with Advanced Services, I ended up with this link, http://www.microsoft.com/en-us/download/details.aspx?id=35579, and every time I install it, I do not ...
Latex Person's user avatar
7 votes
5 answers
49k views

Installing SQL Server 2014 Express fails with error “ Could not find the Database Engine startup handle.”

Let me start by saying I am not a DBA, and I actually don't have alot of database admin experience. I'm just a guy trying to run SQL Server on my local machine to build some simple .NET applications ...
Bugalley's user avatar
7 votes
5 answers
65k views

SQL Server Agent won't start

When I'm trying to start SQL Server Agent, I got this error: TITLE: Microsoft SQL Server Management Studio Unable to start service SQLAGENT$SQL_NAGA on server NAGA. (mscorlib) ADDITIONAL ...
Naga 's user avatar
  • 73
7 votes
1 answer
5k views

Downsides to using SQL 2012 Upgrade as opposed to a fresh install?

I currently have SQL Server 2008 R2 which I would like to upgrade to SQL 2012. I can either un-install SQL 2008 and install a new copy of SQL Server or run the Upgrade. The upgrade is less work but I ...
Dina's user avatar
  • 1,497
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
7 votes
1 answer
2k views

How can Cumulative Updates to SQL Server 2019 be Slipstreamed into a Single Installer?

I'd like to take the latest version of SQL Server (SQL Standard, 15.0.2000.5), and apply the latest CU to it so that I have a single installer, thus reducing the size of the resulting package. The ...
CJBS's user avatar
  • 121
6 votes
3 answers
27k views

Error: Unable to write inside TEMP environment variable path

I am installing PostgreSQL 9.2.4-1-windows.exe on Windows 7 64 with Service Pack 1. I get the following, rather famous it seems, error: There has been an error. Unable to write inside TEMP ...
crthompson's user avatar
6 votes
5 answers
9k views

Is it advantageous to scale out using multiple SQL Server instances on the same server?

For a use-case of 9 databases spread across 3 time zones, is it advantagous to spread the databases onto multiple SQL Server instances on the same server? What will I gain and what will I lose? ...
孔夫子's user avatar
  • 4,330
6 votes
3 answers
1k views

Why SQL Server 2008 R2 do full installation for just adding another instance on the same machine

Why SQL Server 2008 R2 does a full installation for just adding another instance (only database engine) on the same machine? I thought it will be quick a installation, but it's not. What is SQL Server ...
Ganesh's user avatar
  • 63
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
6 votes
1 answer
14k views

Skip multiple rules during SQL Server installation

I want to install SQL Server 2008, but I get 2 errors which prevent me from going forward. I know from this post how to skip one rule. Is there a method to skip both? I am using Wine (PayOnLinux) on ...
Matei's user avatar
  • 63
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

1
2 3 4 5
13