Questions tagged [setup]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
17 views

Proper way to setup oracle database for TCPS SSL in local machine

I am using oracle database 12c and would like to setup TCP SSL connection to be able to connect using the same machine where the database is hosted. So, connection would be from database machine to ...
user avatar
0 votes
0 answers
17 views

MySQL Database Setup Script(s) - Limiting Created User Access

PREFACE: Per comments on my original post, this question will focus on the MySQL-specific elements of my goals. A separate question for the PostgreSQL version has been posted here: PostgreSQL Database ...
user avatar
1 vote
0 answers
67 views

PostgreSQL Database Setup Script(s) - Limiting Created User Access

PREFACE (EDIT): Per comments on my original post, this question has been modified to focus on the PostgreSQL-specific elements of my goals. A separate question for the MySQL version has been posted ...
user avatar
0 votes
1 answer
80 views

What steps are required to setup PostgreSQL and create a db in Windows?

I have installed PostgreSQL 12 from https://www.2ndquadrant.com/en/blog/pginstaller-install-postgresql/. and put \C:\...\PostgreSQL\12\bin in the PATH. In an admin powershell I execute psql.exe -U ...
user avatar
  • 103
0 votes
1 answer
351 views

Why is OracleDB locking up in Docker?

I am trying to set up an Oracle database in Docker, and once the database is up and running, I can exec into sqlplus just fine, but if I try to connect with another application like Oracle SQL ...
user avatar
5 votes
1 answer
4k views

How to turn off logging of "Software Usage Metrics enabled" and ESENT errors

I am running SQL Server 2017 Standard CU 5 in a failover cluster with two nodes (single instance cluster). I have followed these two manuals to deactivate CEIP aka spyware features: The CEIP service ...
user avatar
-1 votes
1 answer
1k views

Microsoft SQL Server setup - how to specify password with SAPWD switch when it contains equal sign (=)? [closed]

I've recently tried to install Microsoft SQL Server setup.exe using well tried syntax I used before, but run into error the because of '=' sign in my user password. See sample command below: setup /...
user avatar
  • 707
0 votes
1 answer
532 views

adcfgclone.pl dbconfig fails when trying to configure the database to use logical host names

adcfgclone.pl dbconfig fails when trying to configure the database to use logical host names. Unable to make database connection, error in ApplyDatabase.log " Exception occurred: java.sql....
user avatar
  • 125
-1 votes
2 answers
999 views

Setting up Oracle XE on Linux

I'm trying to set up oracle-xe on my Linux machine. I just need an environment to play with Oracle SQL; this is not for production. When I try to start SQLPLUS I keep getting one of the following ...
user avatar
  • 103
0 votes
2 answers
4k views

How to correct SQL-Server installation with wrong language?

What is the best way to re-install a SQL Server that was installed using a wrong language without losing any configuration? Should I install a second instance parallel to the default instance - here ...
user avatar
  • 4,635
1 vote
0 answers
705 views

SQL Server (2016) Setup removed permission to drives [duplicate]

I recently installed a new Sql Server 2016 and selected the root of drive N:\ for transaction logs and drive Z:\ for tempdb. In the end the server was succesfully installed and running. But it was ...
user avatar
  • 4,635
0 votes
1 answer
524 views

SQL Server 2008 R2 SP1 - Can't install "Full-text Search"

I have a "Microsoft SQL Server Express 2008 R2 SP1" installation on a machine without the "Advanced Services". Now I want to install the "Full-text Search", so I downloaded the setup "...
user avatar
  • 111
0 votes
1 answer
2k views

How to find existing instances "instance root" (MS SQL)?

I'm installing a new instance of MS SQL. There is a step asking to specify instance root. The current DBA is off but I want to follow his logic / way of doing things. The installer lists the existing ...
user avatar
  • 133
0 votes
1 answer
4k views

Install SQL Server 2012 missing vs_Setup.msi from Visual Studio 2010

I am trying to install SQL Server 2012 Enterprise with SQL Server Data Tools included. I understand that SQL Server Data Tools is part of what was formerly known as BIDS. The installation for SQL ...
user avatar
1 vote
2 answers
15k views

PostgreSQL - pgAdmin error creating a server

I have the latest versions of PostgreSQL and its GUI-frontend, pgAdmin, installed. When I try to register a new server a fatal error appears when pgAdmin tries to connect to the newly created server - ...
user avatar
  • 113
1 vote
1 answer
34 views

New instance with same @@VERSION as existing instances

I have a SQL Server 2008 R2 server with several instances installed. Is there a way to add a new instance and have it be to the same build as the existing (and updated / patched) instances?
user avatar
-1 votes
2 answers
114 views

SQL Server installation prerequisite fails

When I install SQL Server 2008 R2, I get this message: Previous release of Microsoft Visual Studio 2008 -- Failed (screen shot) I can't proceed to the next step. How can I fix this?
user avatar
  • 283
2 votes
1 answer
12k views

Install by command line

I am using following command line to install SQL Server 2008 R2 but its not installing. Also, I am not getting any error or log in summary.txt. "D:\SQLEXPR32_x86_ENU (1).exe" /q /ACTION= Install /...
user avatar
  • 863