Questions tagged [windows]

Operating system produced by Microsoft. Windows is produced in various desktop and server versions. Please also add a version-specific tag like windows-10 if that is relevant to the question.

Filter by
Sorted by
Tagged with
0
votes
2answers
47 views

Can't start Oracle after Virtual Machine restore

As part of a project for a customer of mine, they've given me the complete backup of a physical server (taken by Veeam) which I have then used to make a Bare Metal recovery onto a test VM host I have ...
0
votes
2answers
2k views

Postgres Windows post-install “The database cluster initialization failed”

I've seen many solutions and have been working on this issue for hours now. After installation the post-installation script fails with the message above. This is a development installation of ...
0
votes
0answers
5 views

Ensure 'Adjust memory quotas for a process' is set to 'Administrators, LOCAL SERVICE, NETWORK SERVICE' vulnerability for Windows 2008 R2 SQL

I have a MSSQL Windows 2008 R2 server. Vulnerability for "Ensure 'Adjust memory quotas for a process' is set to 'Administrators, LOCAL SERVICE, NETWORK SERVICE'" has been found. Current ...
0
votes
2answers
121 views

Postgres file increment size

I'm COPY-ing 300 tables / 400G to PG10@win2016server using a few threads to speed things up, but because the table files are incremented in 64-kb units (or something there-about) they get fragmented ...
1
vote
1answer
73 views

Cant install SQL Server 2019

I have a single node Windows 10 Pro machine, 64 bit, with 32GB Ram and an i7 processor. When I try to install the developer edition of Sql Server 2019, it fails installing the Database engine with a ...
0
votes
2answers
29 views

Windows Server 2019 and SQL Server Backups issue?

I have an issue with SQL Server that is really driving me nuts so I wanted to ask if anyone has any suggestions. I have a program that does a daily backup of the SQL Server database. This has worked ...
5
votes
3answers
18k 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 ...
0
votes
0answers
9 views

Change to sa and windows authentiction

I am trying to enable sql server and windows authentication mode by logging into SSMS but when I change to sql server and windows authentication mode and hit OK, I get this pop up enter image ...
0
votes
1answer
11 views

Where is MySQL template directory for pristine Data?

I'm using MySQL 8.0 in Windows. I'm trying to set up multiple servers. And I need to copy the Data directory for it. The MySQL documentation says Windows MSI package installers create and set up the ...
-1
votes
0answers
19 views

How to make PostgreSQL's pg_dump exclude a given table in a given schema?

I'm trying to backup my database and exclude the table "Table Name" from the schema "Schema Name". (My object names contain spaces and non-ASCII characters.) Test 1: pg_dump --...
2
votes
0answers
26 views

Cannot access MYSQL safe mode using skip-grant-tables on Windows

I am running a MySQL server 8.0.21 on a Windows Server system. Recently I ran into an issue where my root user lost all its privileges. I am trying to gain access to the MySQL server using: mysqld ...
0
votes
0answers
10 views

Run MongoDB under a Windows Managed Service Account

In Windows environment can I run MongoDB under a Windows Managed Service Account? the main reason is there is a company policy about PWD expiration each 60 days, and we want to use Managed Service ...
0
votes
1answer
154 views

Cannot shutdown a shutdown connection MySQL Enterprise Monitor

We are facing below errors on MySQL Enterprise Monitor.. While deleting a connection from MySQL Instances it is displaying following error messages. Also it is not deleted event it displays success ...
0
votes
0answers
26 views

upgrade from 9.4 to 9.6 using pg_upgrade fails

I'm using pg_upgrade to upgrade postgresql from 9.4 to 9.6.Both versions are installed on windows server 2016.I followed the steps described in https://www.postgresql.org/docs/current/pgupgrade.html. ...
0
votes
2answers
27 views

Move Oracle to new drive

I have a customer who currently runs Oracle on Windows (not my choice, I just have to deal with their current setup) The basic layout of the server C:\ - operating system and oracle application D:\ - ...
1
vote
1answer
95 views

Share mongo database between two OS on dual boot

Now I have two OS on my computer: Windows 10 and Linux (arch). Sometimes I use Linux but I also use windows because of gaming, and I want to create a small application that is going to work on both OS....
0
votes
1answer
35 views

Need to upgrade SQL Server from 2012 to 2017 on a Server 2008 box

I have been asked to upgrade SQL Server from 2012 to 2017, it is currently installed on a server with Windows 2008 OS. My thinking from what I've researched is this: Take a snapshot of the server ...
0
votes
1answer
14 views

Why mysql-noinstall5.6.x.zip includes ibdata file?

English is not my main language, please feel free to correct me or ask for clarification or a different explanation. I've been messing around with MySQL for Windows and trying to understand how it ...
7
votes
5answers
39k views

Problems connecting to Windows-based Postgresql

Other computers are having trouble even finding the running Postgresql 9.1 on my Windows 7 machine. Local connections work just fine of course. In my pg_hba.conf I have: #office subnets host all ...
1
vote
0answers
38 views

PSQL console encoding

How can I have a working PSQL console using UTF8 encoding under Windows? I have a Windows server and client. The Postgres 12 database contains tables with content in multiple languages (ex: English, ...
1
vote
1answer
256 views

Can't create a Database on Oracle 11g

I'm new on Oracle and I'm trying to create a new database. I followed tutorials online but the problem seems to be in Windows and not in Oracle. I'm using the Oracle assistant to build my Database ...
1
vote
1answer
847 views

Access denied error when archiving WAL during postgresql 9.5 replication setup

I want to setup Postgres replication on Windows. I followed the given youtube url step by step: youtube video. For archive_command I use this: archive_command = 'copy "%p" "\\\\ip-address of ...
3
votes
3answers
7k views

MySql service on Windows won't start after changing datadir

Tried to change the data directory for a default Windows installation of MySQL. Here's the steps I've taken. Stopped the MySql service. Located the data directory of MySql and moved it to another ...
1
vote
1answer
348 views

MySQL Load Balancing what do i need Replication or Cluster?

So My MySQL database server is reaching it's limits with the number of queries selects, updates, inserts etc it can concurrently take resulting in high CPU usage more than what a single machine can ...
0
votes
1answer
4k views

NT SERVICE\MSSQL$SQLEXPRESS user cannot be found when added to network drive

For SQL Server 2016 Express, I would like to backup/restore directly to/from network storage I have mapped to drive S:. SQL Server Express runs under the (virtual?) account NT SERVICE\MSSQL$SQLEXPRESS ...
2
votes
2answers
1k views

Building Oracle XE docker image in Windows 10 Pro

I'm trying to install Oracle XE 18c in a docker container in Windows 10. I have docker already installed, and I need to build the image as explained here. I cloned the git repository, but I'm stuck ...
5
votes
3answers
24k views

Pg install: “The database cluster initialisation failed”

(Note: This question has been compeltely rewritten from its original form, so it reflects the actual problem and will help others find a solution to the same issue). I still haven't been able to ...
1
vote
1answer
14 views

can I exclude or delete .pem files in backup data myqdl?

I am making a backup of the mysql data folder. In this folder are the databases. The method I am using is described in this post which uses ROBOCOPY During installation, mysql (tested in 5.7.30) ...
1
vote
1answer
279 views

Import Windows MySQL dump on a Debian Linux server

I created a test database on a Windows computer with MySQL 5.7 and filled it with many data records. Now I created a database dump with mysqldump and wanted to import it on my server (Debian Jessie, ...
0
votes
0answers
41 views

Powershell script hangs with psql command, continues only after hitting enter

I have a simple powershell script that is supposed to drop an existing schema and restore it from a backup, the script is basically those lines: echo "Dropping Schema MySchema" & $PG_SQL -d "host=...
3
votes
3answers
152 views

what files should I exclude/add/copy mysql dbs (without mysqldump)

I need to have an exact copy of my databases in a clone VM of my server (just in case the server goes down, have the VM ready with the dbs). I know that mysqldump is the best alternative to migrate, ...
3
votes
2answers
2k views

Installing Temporal Tables extension (contrib extension) on windows

I am trying to install this Temporal Tables extension into my localhost installation of PostgreSQL. (pg9.4, windows 7) I have figured out I needed to put the files into the 9.4/share/contrib folder (...
2
votes
3answers
4k views

Workarounds for setting default schema for domain group?

I am currently working on a project for a client, they have asked me to change the database from Oracle to SQL Server. So we migrated the database across to SQL Server 2008, when this was migrated (...
0
votes
1answer
20 views

RMAN-03009: failure of backup command due to ORA-27038 and OSD-04010:

I'm running below script in a windows server, this is same script I run across all servers run { configure retention policy to recovery window of 7 days; backup current controlfile format 'F:\...
1
vote
2answers
389 views

MySQL Upgrade on Windows

I am having MySQL 5.1 installed on windows box. Now I would like to upgrade to latest MySQL 5.6 version. I am planning to install MySQL 5.6 in the same server with same port 3306. After installation, ...
3
votes
2answers
680 views

Unable to get any type of connection using MySQL on LAN

My question is rather simple, I have a Windows 7 machine that is hosting an Apache server and a MySQL server using the XAMPP control panel. Both of these have been installed as a service on the ...
5
votes
1answer
4k views

Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error

Error creating SQL Model Connection connection to TSMDB1. (Error: [jcc][t4][2010][11246][3.68.61] Connection authorization failure occurred. Reason: Local security service non-retryable error. ...
0
votes
2answers
233 views

MySql Replication on Windows

guys any one please give detailed document on Mysql Replication on Windows System.I replicated master to slave, but it is showing 'connecting to master' errorno showing as 1045 and 2003 its varying. ...
0
votes
1answer
1k views

Looping all csv files in local folder for data insert in MySQL db ( Both are local

Below is showing error "for f in 'C:\Users\Documents\TEMP*.csv DO LOAD DATA INFILE '"$f"' INTO TABLE TEMP FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES" DONE" ...
0
votes
1answer
13 views

Mongodb as windows service

I am using mongo db with replica sets. I am starting the mongodb using command prompt. Python Script: os.system('start mongod --configsvr --dbpath C:\mongoConfigData/configdb1 --replSet conf --port ...
0
votes
0answers
18 views

How to remediate the TLS_RSA_WITH_SEED_CBC_SHA on Debian and TLS_RSA_WITH_3DES_EDE_CBC_SHA (SWEET32) on Windows?

I'm in a class right now and we're given two servers to setup and secure. We are supposed to use Greenbone Vulnerability scanner and report/fix what it finds. My windows server is vulnerable to ...
2
votes
1answer
51 views

Can you create a clustered DB in Azure using Windows 2003 and SQL Server 2005?

We need to replicate an environment in Azure, running a clustered DB. The current physical environment is running on Windows 2003 and MS SQL Server 2005 R2. We know that there's no OS/DB support but ...
0
votes
0answers
23 views

How to get the table change script for SQL Server using SSMS 2017?

I'm having frequent table changes in my database, I'm using SSMS 2017, is there any easy mechanism for generating scripts for the changes made to the table. Or Are there any tools for managing this ...
0
votes
1answer
2k views

Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?

MySQL 5.1.x | Windows Server 2003 Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue? For example, if I ...
0
votes
1answer
98 views

Move Mysql database from Windows Xampp to Linux MySql Server

I 'am looking for a way to move some database in my local xampp to remote MySql Server , running into a Linux VM (Centos 7) Any idea or any suggestions to do this migration?
2
votes
1answer
35 views

How am I supposed to update PostgreSQL on Windows, once installed, without manually installing new installers?

I have PostgreSQL 11.5 installed on Windows 10. It was installed with the EnterpriseDB installer, which is the only one which exists these days. If I go to https://www.postgresql.org/download/windows/...
0
votes
0answers
196 views

Postgresql 12.2 “Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed” on windows 10

I get this error whenever I try to install Postgresql 12.2 "Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed". I followed ...
0
votes
1answer
770 views

MySQL server installation file download for windows

I need to install latest MySQL community server 5.6.25 in windows box. MySQL site is giving complete MySQL installer, but not particular MySQL server installation file. Where can I get this ...
0
votes
1answer
89 views

How to resolve MDF and LDF files remaining in use?

I am attempting to copy off approximately 220 gigs of database MDF and LDF files from a MS SQL server 2000 install in order to transfer ownership to a third party. The error I get when I try to stop ...
1
vote
1answer
4k views

Getting error while creating a New Connection using Studio 3T for Mongo DB

I tried to create a new connection with Studio 3T for Mongo DB. I don't have a previous DB connection and this is the new one that I am trying to create it. I can't able to figure out why this is ...

1
2 3 4 5
12