Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
8 votes
4 answers
9k views

Using SQL Server with BitLocker

I have an application that is running on a device that has two partitions: C and D. The application runs off of C while D contains the SQL Server database (mdf file). In addition, D is also encrypted ...
0 votes
1 answer
334 views

Powershell script while executing mysqldump script

I'm having an error 1045: Access denied for user 'mysqlsuperuser'@'test.internal.cloudapp.net' (using password: YES) when trying to connect Here is the mysqldump command on my ps1 file. $command = [...
0 votes
1 answer
319 views

Cannot find sqlserver service

I installed Sql Server 2019 in Windows PC. In Sql Server Configuration Manager into SQL Server Service I stopped all the instances. But still I can loggin to Sql Server via SSMS.why is that? Where is ...
1 vote
1 answer
643 views

Kerberos Issue - Anonymous Login

I have a linked server that connects one SQL Server to another SQL Server. For two weeks now there has been an error when testing the connection; Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. ...
1 vote
1 answer
30 views

Recovered database files, need to be rebuilt using a new SQL server instance [closed]

Need some help in recreating a recovered database. We recently recovered an old disk drive that has the following folders on it: Program Files\Microsoft SQL Server\MSSQL... Program Files(x86)\...
0 votes
1 answer
531 views

PostgreSQL for windows create tablespace on network location (nfs shared) failed because directory not exist

My server is Windows Server 2016. The server mounted a NFS remote storage with below command: mount \\192.168.6.68\nfsshare z: mkdir z:\pg_data All the relevant permissions such as read/write/execute ...
2 votes
1 answer
9k views

How can I troubleshoot issues with dynamic registration?

For testing I have been trying to install Oracle 11g on a test system with a single database several times with the aid of snapshots. This most recent iteration I have been having issues getting the ...
1 vote
1 answer
2k views

Upgrading Postgres 12 to 13: 'pg_upgrade.exe' fails

I'm attempting to upgrade a Postgres instance from version 12 to version 13, following the steps outlined at https://www.postgresql.org/docs/13/pgupgrade.html. From an elevated command prompt, I'm ...
0 votes
1 answer
448 views

How to get rid of all whitespace in a mysql query?

SELECT libary.MediaId, library.Title, library.`date-downloaded`, library.Author, library.`language`, library.asseturl, library.`recycle-bin`, library.`key-asset`, SUBSTRING_INDEX(SUBSTRING_INDEX(`...
13 votes
3 answers
29k views

Logging to a file in PostgreSQL windows service

I need an alternative for running the following command: C:\xxx\pgsql\bin\pg_ctl" -D "C:\xxx\pgsql\data" -l "C:\yyy\log\pgsql.log" start. This way the server starts and logs to C:\yyy\log\pgsql.log. ...
0 votes
2 answers
283 views

Failing over to DR site Availability group

I have a 4 node cluster SQL 2012 availability group database with one witness server at the primary site. 3 nodes are in the primary site and one node in the DR site. Due to maintenance at the Primary ...
0 votes
1 answer
1k views

Unable to remote connect to windows 10 Postgresql

Context I have an old laptop I'd like to host a database on to serve a MEVN stack hosted on AWS. That MEVN stack currently does use Mongo, the goal is to transition to a local (my laptop) Postgresql ...
1 vote
1 answer
666 views

Any idea what Virtual Machine Cluster WMI is for?

We have a Windows Failover Cluster to host our SQL Server Availability Group. We have a resource that popped up that no one recalls creating named "Virtual Machine Cluster WMI". We have ...
2 votes
1 answer
7k views

SQL Server - allocation unit size in Windows 2019

I'm about to install a SQL Server 2019 instance on a Windows 2019 machine and found out that there are new NTFS allocation unit sizes available - up to 2M. I used to format partitions using 64k unit ...
0 votes
1 answer
299 views

Is there any option to enable Window NT logs in SQL Server Logs

I'm trying to view SQL Server logs on a specific server and is missing Windows NT section in same. Though other server are showing that section. In the screenshot shared below, I highlighted section ...
1 vote
1 answer
2k views

Getting "unknown variable postgresqlini" when updating PostgreSQL

I am getting an error when attempting to upgrade a PostgreSQL installation. The full error is: A data directory is registered in ***unknown variable postgresqlini*** but is neither empty or a ...
2 votes
1 answer
2k 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
1 answer
1k views

Reset mongo cache memory for test perfomance - windows

recently i'm working on mongo db and I'm trying to check the performance of mongodb with 2 million record. I need to clear cache every time I start the test. I don't want to restart the computer/...
2 votes
1 answer
4k 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
2 answers
288 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 ...
10 votes
2 answers
26k views

Changing Data Directory on MySQL DB Server

I have installed mysql server 5.6.24 on Windows Server 2012 R2. I imported dump files and the data files are stored in C:\ProgramData\MySQL\MySQL Server 5.6\data I want to change directory like D:\...
0 votes
0 answers
39 views

ORA-12541: TNS:no listener error when trying to login through WSL to access OracleXE Database

System Details WSL2 Ubuntu Oracle Instant Client (Inside of WSL) OracleXE (Inside of Windows) I followed the instructions guide from the Oracle Documentation, added the path to the TNS_ADMIN, ...
0 votes
0 answers
189 views

How can I check the current memory management mode for an oracle database instance?

I have a vendor requesting that Automatic Shared Memory Management (ASMM) is configured to a certain threshold for an existing oracle database (version 19c) hosted on a windows box. As usual Oracle ...
2 votes
2 answers
475 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, ...
1 vote
1 answer
10k 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 ...
0 votes
1 answer
741 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?
1 vote
1 answer
565 views

MySQL stops in windows VM and shows innodb os error in logs(error no. 5)

2020-08-23 17:22:36 5688 [Note] Plugin 'FEDERATED' is disabled. 2020-08-23 17:22:36 5688 [Note] InnoDB: Using atomics to ref count buffer pool pages 2020-08-23 17:22:36 5688 [Note] InnoDB: The InnoDB ...
0 votes
1 answer
1k views

How to programmatically find the PostgreSQL data directory?

I'm creating an installer for my program and I'd like to check if the database already exists in the computer. I do this by calling psql -lqt | findstr dbname. If someone knows a better way I`ll be ...
0 votes
1 answer
310 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 ...
0 votes
0 answers
42 views

copying data from database with the same skeleton

I have a database design with the same tables, procedures and all other details on two different servers. Since one of them ran out of traffic, I forwarded the web software project to the other one. I ...
0 votes
1 answer
3k 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 ...
2 votes
2 answers
5k 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
1 answer
729 views

PostgreSQL data corruption tools?

Are there any techniques/tools/methodologies for investigating row level corruption within a PostgreSQL table? Most proposed solutions on this forum boil down to: try doing a VACUUM FULL to rebuild ...
2 votes
2 answers
3k views

Error while configuring REST for Oracle APEX on Windows

I'm trying to deploy Oracle APEX 18 on Windows 8.1 PC using Oracle REST Data Services and Oracle Database 18c XE following this guide. But when I'm trying to run @apex_rest_config.sql I get this ...
0 votes
0 answers
26 views

DB2 SQL1052N createing a database

SQL1052N is path not found when running CREATE DATABASE.... But I get this every time I specify a path in the statement, even when the path is there and is created by the same user. The path exists ...
0 votes
1 answer
32 views

Can automatic failover occur to a DR node on a different data center if synchronous commit is enabled and other conditions are right

Can automatic failover occur to a DR node on a different data center if synchronous commit is enabled and other conditions are right. I'm asking because we had a two node scenario where a primary node ...
2 votes
1 answer
13k views

The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server)

we have an issue connecting remotely to SQL Server via SSMS with Azure AD users. Any attempt to log in to a SQL Server instance in AWS with Windows Authentication throws an SSPI error. We've tried the ...
0 votes
0 answers
179 views

Cannot cannot to database using sql developer: a connection attempt failed because the connected party did not properly respond after a period

I am using a windows laptop and installed sql developer version 23.1.0. When I input the connection details for my database I get the following error: a connection attempt failed because the ...
1 vote
1 answer
30 views

How can I get PostgreSQL to follow up filtering jobs that my FDW ignored?

I'm making a FDW (Foreign Data Wrapper) in PostgreSQL for myself using C. It seems to be working rudimentary, but I have one problem. When I pass it a query like the following via psql: select * from ...
0 votes
1 answer
167 views

Availability group issues - databases not synchronising

I am hoping someone may be able to offer some assistance with an issue that I do not seem to be able to work around. We have 2 on-premise SQL Server 2019 machines in an always on availability group. ...
0 votes
1 answer
177 views

Got an error when trying to get ER-diagram on SQL Server

We are using Microsoft SQL Server 2016 Management Studio (version 13.0.16106.4) connecting to an instance of SQL Server 2016 running on Windows 2016. The authentication is "SQL Server ...
0 votes
1 answer
208 views

Confusion on SQL Server domain\username after Windows changing hostname

We have a SQL Server 2016 running on a virtual machine of Windows 2016. Previously, the virtual machine's hostname was WIN when we installed the SQL Server, so the database engine's server name was ...
10 votes
3 answers
25k views

issues with encoding and pg_dump/restore between windows and linux

I have a dmp file I have created using pg_dump encoded in WIN1252. What I would like to do is import it using pg_restore to a database on a Linux machine. The problem is that on the windows machine ...
6 votes
2 answers
9k views

Binlog has bad magic number

I keep getting this error whenever I start MySQL. 121028 1:38:55 [Note] Plugin 'FEDERATED' is disabled. 121028 1:38:55 InnoDB: The InnoDB memory heap is disabled 121028 1:38:55 InnoDB: Mutexes and ...
0 votes
1 answer
2k views

postgres: could not access directory "C:/opt/PostgreSql/14/data": Permission denied

Importantly: This is on Windows 10 and Postgres 14 (for newbies, Postgres is also known as PostgreSQL), with Cygwin providing the CLI. On a fully functional, up and running, and apparently perfectly ...
0 votes
0 answers
38 views

Mongo 3.4 to 3.6

How to upgrade 3.4 mongo to 3.6 mongo. I don't have config file while starting mongodb in 3.4 how to have it in windows locally.
0 votes
0 answers
59 views

My SSMS does't see the directory with db files

I did nothing and my SSMS does not see db directories with files. When I'm trying attach db ssmms can't find this way. But when I create db the files put there As I understood there is the problem ...
12 votes
3 answers
73k views

pgAdmin 4: How to establish a connection through an SSH tunnel/interface in Windows

I installed the latest pgAdmin 4 (v2.1) but I found out that (related thread), for the moment, the only way to establish a connection through an SSH tunneling is using another outside process, an ...
0 votes
1 answer
140 views

MariaDB Power Outage Issue

We have a desktop application on Windows OS that installs with MariaDB server 10.4.10. Sometimes the client loses power and after restarting of PC MariaDB database becomes corrupted and Windows Server ...
0 votes
1 answer
856 views

MySQL 8 install doesn't include mysql.exe (Windows). Where to get it from? [closed]

I've installed MySQL 8.0 using mysql-installer-community-8.0.26.0.msi. Mainly these options: But there's no binaries for connecting (mysql.exe) or dumping (mysqldump.exe): What else do I need to ...

1
2 3 4 5
14