Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [setup]

19 questions
5
votes
1 answer

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 is disabled and stopped, the CEIP role removed…
Martin Guth
  • 715
  • 1
  • 8
  • 22
3
votes
1 answer

PostgreSQL Single, Local User Setup

I used PostgreSQL briefly, many, many years ago for some very simple personal databases but then moved to SQLite for it's administration. However I now want to use some large datasets and would like to use Postgres. I only want a single user on a…
John
  • 133
  • 4
2
votes
1 answer

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 /FEATURES=SQL /INSTANCENAME=nvt /SECURITYMODE=SQL…
Navaneet
  • 923
  • 5
  • 12
  • 23
2
votes
3 answers

SQL Server 2022 setup silently closes with no clue

When trying to install SQL Server 2022 from iso, I can't get setup wizard doing a single (visible) action when I click the "New SQL Server standalone installation" link. Everything seems being blocked at landingPage.exe startup. All I can get from…
tivivi
  • 41
  • 1
  • 6
1
vote
2 answers

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 - password authentication failed for user…
Venom
  • 113
  • 1
  • 1
  • 4
1
vote
1 answer

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?
Bryan Smith
  • 137
  • 3
1
vote
0 answers

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 here: MySQL Database Setup Script(s) - Limiting…
G_Hosa_Phat
  • 445
  • 2
  • 5
  • 16
1
vote
0 answers

SQL Server (2016) Setup removed permission to drives

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 not possible to access the drives N or Z anymore.…
Magier
  • 4,827
  • 8
  • 48
  • 91
0
votes
1 answer

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 instances but does not specify the configured…
Alex
  • 133
  • 1
  • 7
0
votes
1 answer

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 Server 2012 prompts me for the ms_setup.msi…
Ash Machine
  • 101
  • 1
  • 2
0
votes
1 answer

Is it possible to add a PostgreSQL hot standby using pg_createcluster to a primary created with initdb?

Hi we are using PostgreSQL 16 on Ubuntu 22 LTS and have built a cluster using initdb. I'm wondering if it's possible to rebuild a standby using pg_createcluster instead to take advantage of various admin tools and join it to the cluster so that we…
Di Si
  • 3
  • 2
0
votes
1 answer

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 postgres and enter the password I chose in the…
user2740
  • 157
  • 1
  • 5
0
votes
1 answer

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.SQLRecoverableException: IO Error: The Network Adapter…
SeanClt
  • 125
  • 9
0
votes
2 answers

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 I do not know if this is anyhow possible at all…
Magier
  • 4,827
  • 8
  • 48
  • 91
0
votes
1 answer

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 "SQLEXPRADV_x64_DEU.exe". The problem is, if I start the setup,…
roli09
  • 111
  • 1
1
2