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
0answers
29 views

Getting "the referenced assembly could not be found. Error:0x80073701" while installing windows feature failover clustering [closed]

We are trying to install Failover Clustering windows feature from Server Manager: Windows Feature Description and getting below error: The request to add or remove features on the specified server ...
2
votes
1answer
52 views

How do I identify the users on Oracle database who uses OS authentication?

I'm trying to audit the privileged users on Oracle Db and see there are users for whom the last login column appears to be blank, however, I'm aware that those user accounts are used for certain ...
0
votes
0answers
21 views

What is the intended method for automatically/streamlinedly updating minor/patch PostgreSQL versions on Windows?

I currently run PostgreSQL 12.4 on Windows 10. Since the "BigSQL" distribution is no longer around, the only choice is to use the EnterpriseDB installer for the initial installation: https://...
0
votes
1answer
14 views

MySQL 8 install doesn't include mysql.exe (Windows)

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 ...
0
votes
1answer
46 views

how can resolve a cyclic redundancy check sql

i need to restore a database but i have a strong problem, please look the photo, is a strange error, please helpme
0
votes
1answer
101 views

How can I create a mysql database (if it doesn't exist) or replace it (if it exists)?

My dump: mysqldump --host=localhost --user=root --password=whatever --single-transaction --routines --triggers --log-error=error.txt --databases mydatabase > out.sql My restore mysql --host=...
0
votes
0answers
17 views

rotate error log file of MySQL 8.0 server over windows

we have MySQL 8.0 installed over windows and my err log file (.err) is very large (11 GB), so we need to rotate the error loge so it writes to a new file when the current file is 200 MB we tried to ...
3
votes
1answer
63 views

Why putting SQL Agent offline caused WSFC to fail over on passive node?

I have 2 node Windows Failover Cluster with Quorum disk. SQL agent is NOT a resource of the cluster. I needed to enable service broker on the server; for that I need to set SQL Agent offline, run tsql ...
0
votes
1answer
30 views

Why can't I use command \i on psql? It says no such file or directory [closed]

I am trying to use command \i 'C:\Users\Public\person.sql'; on windows on psql. And it says C:UsersPublicperson.sql: No such file or directory Although file does exist. I tried to relocate file on ...
0
votes
1answer
25 views

How to run postgres in-memory on windows and sync to FS when a temer runs out?

So Progress is slow for me (in terms of query and update times) on SSD and it is ok in my case: I use it as a mix of Graph database + Table processor + NoSQL JSON trees so lots of loops, graphs, trees,...
0
votes
0answers
299 views

Oracle 19c listener stops on connection TNS-12541 error

I have just installed Oracle 19c Standard Edition 2 on Windows 10 and created a local database. I can connect to it with sqlplus / sysdba, but if I try to connect with sqlplus user/password@host:port, ...
0
votes
1answer
99 views

MariaDB 10.5 How to Prevent High Memory Usage on Windows

I am running MariaDB 10.5 on I am having trouble with MariaDB using too much memory on my Windows 10 machine. I have 16GB of RAM, and MariaDB ends up using around 8GB. SHOW VARIABLES; https://pastebin....
0
votes
0answers
20 views

Is there a way to purge a DTC transaction from command line?

as you can see on my screenshot, I have a DTC transaction in error on my server. I know, I can Right -> Resolve -> Forget/Abort However, I want to do it with a command line (batch or Powershell)....
1
vote
1answer
35 views

Mysql (win) Is it possible to get databases from multiple drives in the same time?

My question would be, is there any way to read the mysql data folder from different drives in the same time (Windows) ? For example: I have 1TB database from the drive C:, and another 1TB from the ...
-1
votes
1answer
35 views

Best Database to be shipped with my application? [closed]

I have a .NET core application using a database. I need to create an installer using NSIS where I will be packaging my application along with a database, so that the client can easily install my ...
0
votes
1answer
24 views

How to configure account to be able to create/delete folders and files?

I have a newly created domain account (domainname\user1). This will be used by SQL server agent job proxy credential to run a SSIS package that creates/deletes files and folders on the same computer ...
1
vote
2answers
39 views

Why does linked server need delegation where as file access require no delegation settings?

I have a ssis package deployed to ssis catalog in ServerA. It is configured to be run via sql agent job step. The job step is set to Run As proxy user that is pointing to a domain user credential. ...
-1
votes
1answer
103 views

Linux PostgreSQL mount data from external ntfs disk [closed]

I have similar problem as here: Postgres tablespace on mounted usb I want to have access to my DB on external hard drive from Raspbian and Windows 10. Not simultaneously. I just want cross-platform DB ...
1
vote
1answer
473 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
1answer
5k views

The pgAdmin 4 server could not be contacted

Whenever I install PostgreSQL, it stops working after about 6 months. This is the second time this happened! Last time this happened, I uninstalled and then installed version 4.29. How can I debug ...
1
vote
1answer
151 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'. ...
0
votes
0answers
105 views

MariaDB starts from cmd prompt but not as service

Attempting to start MariaDB as a service results in an error that says: Windows could not start the MariaDB service on Local Computer Error 1053: The service did not respond to the start or control ...
0
votes
1answer
53 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 ...
0
votes
1answer
56 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
3answers
60 views

Postgres psql requires " FROM database.table" in sql statement [duplicate]

As a beginning learner of of Postgres I have created two different installations of a database where one requires a select statement to use ...FROM database.table... and the other only requires ......
0
votes
1answer
89 views

Install PFX certificate on SQL 2008 R2

We have a MS SQL 2008 R2 service running on a Windows 7 computer. I've developed a webapplication that runs on a Digital Ocean droplet. This droplet makes a connection with this computer through a ...
0
votes
2answers
57 views

Do I need a domain controller for multiple PCs accessing the same SQL server db? How do I configure it?

(more details/replicate from: https://superuser.com/questions/1612260) Dear all, I'm a total newbie in connecting 2 PCs and making them use the same SQL server DB from one computer ... so please ...
1
vote
1answer
177 views

Cannot Reset MySQL password

I have been stuck on this for a long time, I tried to follow the instructions located here: https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html. When I run the commands I get this as my ...
0
votes
1answer
63 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 ...
0
votes
0answers
86 views

What's the problem with my password while installing Apex 20.1?

I am installing Apex 20.1 on my windows 10 with oracle 19c. After running the command : @apxchpwd.sql I get this error even after respecting all the password regulation and trying different ...
0
votes
1answer
32 views

T-SQL code to see Windows Folder access

Does anyone know how to check from T-SQL code in a stored procedure if a SQL user have read access to a WIN folder that is mapped to the SQL server? Thx Erik
0
votes
0answers
17 views

MySQL only supported on Windows - 3rd party vendor

We have a 3rd party vendor currently indicating that their application only supports MySQL on Windows, and cannot work with MySQL on Linux or RDS. As far as I know, MySQL is MySQL, it doesn't matter ...
0
votes
1answer
219 views

How to store and work from a Postgresql database on an external hard drive?

I have installed PostgreSQL 13.1 on two computers, a laptop and desktop. I created database using a Tablespace on a portable SSD drive under F:\MyProject\DB\PG_13_202007201\20350. So I expect all the ...
0
votes
1answer
2k views

Connect DBeaver to PostgreSQL 13

I've been using PostgreSQL 10 and 12 on Windows successfully with DBeaver in the past. Now I've set up a new development machine and installed the current PostgreSQL 13.0.1 and the current DBeaver 7.2....
1
vote
1answer
289 views

MySQL no longer starting "An attempt was made to access a socket in a way forbidden by its access permissions." (Windows 10)

I don't think this is another "some other process is using port 3306 rtfm" kinda question. I have been running MySQL 8.0.x fine for a couple of months on Windows 10 for some local python ...
1
vote
0answers
212 views

WSL2 Docker Oracle volume mapping: how to switch from Windows to Linux file system

I am running Oracle (V19, V18, and V12) instances under WSL2 (Windows 10 version 2004). For persistence, my Oracle data files are mapped to a folder on my Windows host. I can run the containers from ...
0
votes
1answer
349 views

Cannot connect to Oracle 19 instance running in a container under Ubuntu 20.04 via WSL2 on Docker for Windows

Here is my docker-compose.yml file: version: '3.7' services: database: image: scgain.azurecr.io/databases/${IMAGE_NAME} environment: - ORACLE_SID=${SID} - ORACLE_PDB=${PDB} ...
2
votes
2answers
30 views

How to filters data with two windows conditions?

I want to get the result of two sub-queries. In my case I have users, user can have multiple access for doors, but sometimes doors are disabled so the access exist but do not point to any doors. I ...
0
votes
1answer
50 views

SQL Authenticated Account is unable to select a View in MS SQL Server

I am trying to select a view using a SQL authenticated account. This view is actually reading a spreadsheet from a local drive (through a LinkedServer). I am getting below error: Msg 7416, Level 16, ...
2
votes
2answers
115 views

What is the best configuration for a MySQL instance with a lot of databases and lot of tables?

I have a MySQL database instance with more than 3000 databases in it. Each database contains more than 200 tables. Total data of all theses database comes around 100 GB. I am using Windows Server ...
1
vote
1answer
34 views

I need a way to give a sql authenticated user read access to a windows directory

A SQL-authenticated user SBA_USER is selecting from a View which uses Linked Server which points to an Excel spreadsheet in the I:\Folder directory on a windows server. Problem I have is that the ...
0
votes
0answers
11 views

Sharing MySQL data folder between Windows and Linux [duplicate]

I have dual boot laptop with Windows 7 and Linux. I've been working for a long time on Windows programming in php / Apache / MySql. I share NTFS partition with Linux which is mounted using ntfs-3g, it ...
1
vote
1answer
650 views

How can I get LOAD DATA LOCAL INFILE to work for MySQL 8.0.21 on a Windows machine? [closed]

I've created a file: 'C:\fff.txt' which contains data for my database table. Then I'm trying to load data from that file like this: LOAD DATA LOCAL INFILE 'C:\\fff.txt' INTO TABLE fff LINES TERMINATED ...
0
votes
1answer
114 views

Oracle listener does not restart because port 1521 is not released fast enough after stop

I'm running Oracle 11g on a Windows 2012R2 server. For some reason we have some code that try to restart the listener and then perform a connection. This code has been working for years on many ...
-2
votes
2answers
100 views

How can I save the MySQL query output to file on a Windows machine?

Let's say I want to save the whole list of the collations supported by MySQL into file. How can I save the result of the show collation into .txt file? The OS I'm using is Windows. I tried something ...
0
votes
0answers
263 views

MySQL server on Microsoft Surface Pro X (ARM-64) work around?

I've been given a surface pro X laptop/tablet(?) which has been purchased for one of the hands-on finance directors who like to browse the database for the company I'm working for. On the looks of it ...
0
votes
1answer
28 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 ...
0
votes
1answer
42 views

Why pgadmin dont enter in admin panel?

I install postgresql-12.4 on my win pc. When i'm trying to enter into admin panel (pgadmin) i cathcing message: could not connect to server: Connection refused (0x0000274D/10061) Is the server running ...
0
votes
0answers
699 views

Innodb error log sequence number is in future

2020-08-28 16:46:02 d64 InnoDB: Error: page 1 log sequence number 23113680 InnoDB: is in the future! Current system log sequence number 3181581. InnoDB: Your database may be corrupt or you may have ...
0
votes
0answers
160 views

pg_repack binaries under windows

We use postgres to manage our data in windows. Most of our installations run 9.x branch of postgres, although all versions of the database software is used (however pretty much all installations run ...

1
2 3 4 5
13