Questions tagged [windows-10]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
23 votes
7 answers
83k views

The operating system returned error 21 (The device is not ready.)

Every time I reboot Windows, for some databases I get this error: The operating system returned error 21(The device is not ready.) I checked the disk with chkdsk /r - no bad sectors. I executed ...
Max's user avatar
  • 471
14 votes
3 answers
30k views

Microsoft SQL Server local report culture is not supported: 3072 is invalide culture identifer

I am using Windows 10, language Serbian, SQL Management Studio 2016 and can't use Database reports because there is error: An error occurred during local report processing Culture is not ...
Jelena's user avatar
  • 143
13 votes
1 answer
6k views

PostgreSQL 9.5 won't start after Windows 10 fall update

I've installed Windows 10 Fall update (1709) and now my PostgreSQL 9.5 server won't start. It worked yesterday before the update and I haven't made any changes to the configuration. I've checked ...
jvb's user avatar
  • 261
10 votes
2 answers
82k views

SQL Server 2000 on Windows 10

I need to install SQL Server MSDE 2000 SP4 on Windows 10. I have other machines that run Windows 7 and 8.1 and SQL Server MSDE 2000 works fine (with merge replication configured too). Now I testing ...
KronosInfo's user avatar
9 votes
1 answer
17k views

SQL Server Services empty in SQL Server configuration

As I upgraded from Windows 8.1 to Windows 10, I noticed that the SQL Server Services in SQL Server Configuration Manager is empty. SQL Server still works perfectly well at the moment. SQL Server 2014 ...
UpwardD's user avatar
  • 385
8 votes
3 answers
58k views

Maintaining SQL Server 2008 R2 on Windows 10

I have to run SQL Server 2008 R2 on Windows 10 but it is not supported and so I am not getting any updates. Installing a later version of SQL Server is not an option. I can find all the service packs ...
Peter Smith's user avatar
5 votes
1 answer
3k views

Unable to uninstall Sql Server 2012 Express (With SP1)

My Stack: . Windows 10 Enterprise . SQL Server 2012 Express (with SP1 bundled). ISSUE: . Installed SQL to test for backward compatibility. . When I tried to Un-Install the following prompt is thrown....
Ifeanyi Ofoborh's user avatar
4 votes
2 answers
7k views

MySQL - Slow InnoDB Write Speeds on Windows 10

I have Windows 10 bootcamped. I've installed the latest version of MySQL community server. I've also installed WordPress onto IIS. The MacBook has 16Gb of memory. Here is my config file [client] no-...
pee2pee's user avatar
  • 194
4 votes
3 answers
2k views

Can't restart Postgres on Windows 10 with external drive

I've been working on a postgres database, with my data directory on my 8TB external USB drive. Occasionally, I need to restart the postgres instance to change configuration settings, but for some ...
Rob G's user avatar
  • 149
3 votes
1 answer
4k views

SSMS crashes when attempting to create a database diagram

I'm currently using the latest version of SSMS (17.8.1) on windows 10 and everytime I try to create a database diagram it crashes without giving me any error message. I've already tried to re-install ...
Mattia Nocerino's user avatar
3 votes
2 answers
2k views

SQL Server 2014 Developer on Windows 10?

Has anyone tried to use SQL Server 2014 Developer Edition (64 bit) on Windows 10 yet? I have a Lenovo G50-45 laptop that came with Windows 8.1 and I have the option to upgrade, but I don't want to ...
Social Exodus's user avatar
2 votes
4 answers
4k views

SQL Server 2014 SP1 Setup Freezes Removing Temporary Files On Windows 10 x64

I want to install SQL Server 2014 Enterprise Edition with Service Pack 1 on Windows 10. But when I try, the installation stops every time at the part the screenshot below shows, and I wait for hours. ...
rockenpeace's user avatar
2 votes
1 answer
3k views

Is Windows 10 compatible with SQL Server 2014 Developer MDS?

I have recently installed SQL Server 2014 Developer edition onto my PN, which has Windows 10 Professional installed. I upgraded from Windows 7 Pro to Windows 10 Pro last year as it was a free update ...
w0051977's user avatar
  • 503
2 votes
1 answer
1k views

Old ODBC app throws "cannot generate sspi context" on Windows 10

An old Access 2003 .adp project is currently running on Windows 7 machines, while SQL Server 2008 is on the backend. Since the app is moved to a Windows 10 machine, the app will trigger "Cannot ...
Riccardo's user avatar
  • 135
2 votes
1 answer
12k views

pgAgent service for PostgreSQL does not run

OS: Windows 10 PostgreSQL 11.4 I Installed PgAgent with Stackbuilder setup. In Windows services; PostgreServer service is running. However, the pgAgent service is stopped. When I try to start ...
tomatoeshift's user avatar
2 votes
1 answer
5k views

How to relax file permissions conditions on postgres database folder?

Postgresql service refuses to start if the data folder (PGDATA) doesn't belong exclusively to the postgres user (i.e. permissions = 700). Is there any way to disable or circumvent that condition? ...
user3748764's user avatar
2 votes
0 answers
384 views

All but one of my SQL Server 2017 databases are GONE after Windows 10 nightly update failure

EDIT: Restored to a restore point from three days ago, prior to a "Critical Update", and the databases are back. This is, I believe, the culprit update: September 10, 2019-KB4514601 Cumulative Update ...
Tim's user avatar
  • 545
2 votes
1 answer
903 views

Connection's MAC address randomly changes on Windows 10, then stops

Because reasons (tm), we want to identify the client's MAC address on SQL Server side (local network, not about security, enables a very convenient feature in way transparent for applications). We do ...
GSerg's user avatar
  • 1,342
1 vote
3 answers
1k views

Practicing AlwaysOn on SQL Server 2014 - Windows 10 Home

TL;DR: What possible solution(s) are there to practice AlwaysOn feature on SQL server 2014 installed on Windows 10 Home edition? I am learning Database Administration on my own and have installed ...
Aun's user avatar
  • 11
1 vote
1 answer
2k views

SQL Server 2016 Plugin's not working [closed]

Recently I installed SQL Server 2016 on my PC. Here is the detailed information of my server : Microsoft SQL Server 2016 (RC1) - 13.0.1200.242 (X64) Mar 10 2016 16:49:45 Copyright (c) ...
Pரதீப்'s user avatar
1 vote
2 answers
3k views

Postgresql 14 on Windows 10: pg_ctl.exe returns is not a database cluster directory

I have installed postgresql 14 on a Windows 10 machine. But, I'm getting this message: C:\Program Files\PostgreSQL\14\bin > pg_ctl.exe start -D "C:\postgres" pg_ctl: directory "C:/...
nephewtom's user avatar
  • 151
1 vote
3 answers
5k views

Which driver should I choose for ODBC connect from Windows 10 => SQL Server 2014

What driver to use for ODBC connection from Windows 10 host to SQL Server 2014? I have a choice of 3 SQL Server clients: ODBC Client 11 SQL Server SQL Server Native Client. I've tried the ODBC ...
Darrel Lee's user avatar
1 vote
1 answer
1k views

How to restore one mysql database with mysqldump

to make a backup I run: mysqldump --host=localhost --user=root --password=whatever --single-transaction --routines --triggers --log-error=error.txt mydatabase > out.sql Is it possible to do the ...
acgbox's user avatar
  • 157
1 vote
2 answers
2k views

MySQL 8.0.24 Windows 10 crashes [not] resolved by reboot, [requires mySQL optimizer tweak]

MySQL 8.0.24 on Windows 10 (10.0.18363.0) crashes near the same point when running a final results query, but only after data input queries with many more records have been run. A restart of the MySQL ...
wistlo's user avatar
  • 119
1 vote
2 answers
2k views

How to set up signed SSL Root and Leaf certificates on a PostgreSQL 11 database on Ubuntu and Windows 10 Power BI plus PostgreSQL?

I have Power BI and PostgreSQL 11 installed on Windows 10 and my primary PostgreSQL 11 database on Ubuntu 18.10 Linux. I edited the postgresql.conf and pg_hba.conf files correctly to the IP Adresses ...
Humble-Data-22's user avatar
1 vote
1 answer
6k 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 ...
bilpor's user avatar
  • 111
1 vote
2 answers
7k views

How to set cache on windows 10 pro 64bit machine

When running Mongod I get the following WARNING: The file system cache of this machine is configured to be greater than 40% of the total memory. This can lead to increased memory pressure and poor ...
DCR's user avatar
  • 171
1 vote
1 answer
4k views

Install SQL Server 2014 in windows 10 not installing database engine and some features?

Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068054016 Start time: 2016-03-27 17:00:55 End time: ...
DAre G's user avatar
  • 11
1 vote
0 answers
51 views

Postgres - now to optimise a table for high frequency INSERTs?

I need to load data into a table as fast as possible. So far I've done the following. Create the table UNLOGGED Removed all indexes Removed all triggers Created the table in a tablespace on a SSD ...
ConanTheGerbil's user avatar
1 vote
0 answers
512 views

SQL Server Management Studio compatible with Windows 10 32 bit

I'm running a VM with Windows 10 32 bit OS and I need to install SQL Server Management Studio. The OS on my VM OS Name: Microsoft Windows 10 Pro OS Version: 10.0.19044 ...
sergiom's user avatar
  • 159
1 vote
0 answers
1k views

PostgreSQL: "PANIC: out of memory"

Got an error while running an application connected to a PostgreSQL DB (10.12). All the connections got disconnected, looking through the server logs, I found the below. TopMemoryContext: 292488 ...
ChrisMM's user avatar
  • 121
1 vote
0 answers
1k views

ODBC from Win10 32bit client only connects using IP address, but not using hostname

I'm experiencing a pretty strange problem. We're using a MS SQL based quality assurance software. The database is hosted on a MS SQL 2016 Std. server running on a Windows Server 2012 R2 VM. Our ...
user3744122's user avatar
1 vote
0 answers
74 views

Deployed application (Oracle 11g, VB.NET 2015 and Crystal Reports) cannot connect to database

I'm developing an application using Oracle 11g, VB.NET 2015 and Crystal Reports on Windows 10. I created a package and installed it on another PC on same network. The package is running fine but ...
Ejaz Sarwar's user avatar
1 vote
0 answers
709 views

PostgreSQL service stops immediately after installing Windows Fall Creators Update 1709

The server itself runs fine with pg_ctl -D <datadir> start But the service stops immediately ("...Some services stop automatically if they are not in use by other services or programs") ...
Gunnar's user avatar
  • 121
1 vote
0 answers
824 views

How to run Oracle Client 10g from non Administrator account?

Hi I have 2 users configured on my Windows 10 Home machine. One is Administrator and another is my own user. Although my user is configured as an Administrator, I can use Oracle Client 10g from my ...
Mayank's user avatar
  • 11
1 vote
1 answer
12k views

'SSL is required but the server doesn't support it (2026)' error while making an SSL MySQL connection

I'm trying to make an SSL supported connection using MySQL Workbench 6.3.9. My OS is Windows 10 x64 and I have installed MySQL Server 5.7 x64 with OpenSSL-1.0.2L (Win64 version). I made a non-SSL ...
Zerthimon's user avatar
  • 111
1 vote
1 answer
19k views

IO Error: Got minus one from a read call [closed]

I am very new with Oracle, I have installed 11g 64 bit on my Windows 10. And only started the oracle database using emctl start dbconsole. I have the following code to be connected to my database, ...
Yahya Hassanzadeh's user avatar
1 vote
0 answers
131 views

How do install and configure Grid Infastructure on Windows>

I'm studying for the 1Z0-062 exam with John Watson's exam guide and I'm trying to install Grid Infrastructure alongside my Dbhome. The book seems to run an installer that displays a configuration ...
user124864's user avatar
1 vote
1 answer
443 views

Using linked server from Windows 10 PC [closed]

I have been using SQL Server linked servers for years, and they have been working fine. But now when I try to run a query (on a machine with Windows 10) using linked server I get this error: Login ...
Stewen's user avatar
  • 11
1 vote
1 answer
478 views

SQL server memory pressure

First observed few months ago at end-user's laptop (rather slow i3 CPU, 4GB RAM, SSD) with SQL 2014 Express. The problem persists with SQL 2019, even with clean Windows 10 1903 installation. The ...
Jan Zahradník's user avatar
0 votes
1 answer
509 views

SQL Server 2005 error after update to windows 10 [closed]

I have a SQL Server 2005 database that I can see in SQL Server Management Studio Express. There is a front end application, but since the upgrade to Windows 10, I cannot access the database with it. ...
Aquamarine's user avatar
0 votes
1 answer
1k views

SQL Server service start automatically only after Windows Shutdown, how can I make restart automatically without batch file? [duplicate]

I am using MS SQL Server 2014, When I restart my Pc the SQL Server Service does not start automatically, however, it does after Windows Shutdown and run again, how can I make it restart automatically ?...
Yousef Albakoush's user avatar
0 votes
1 answer
5k views

Can't install Oracle 11g [closed]

Error while installing Oracle 11g: Please find the StackTrace of this error. ID: oracle.install.driver.oui.OUISetupDriver:13 oracle.cluster.verification.PreReqNotSupportedException: Reference data ...
beskar's user avatar
  • 13
0 votes
1 answer
3k views

Recovering InnoDB database from backed up “data” folder in XAMP in Windows 10

I copied the data directory from mysql folder and uninstalled the XAMPP as the MariaDB was not starting. I installed XAMPP same version and backed up the data folder into mysql data directory. At ...
Sourav's user avatar
  • 121
0 votes
2 answers
165 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 ...
radui's user avatar
  • 101
0 votes
1 answer
26 views

Is it safe to use the Windows "Compress directory to save space" feature on the directory that contains my MySQL general log file?

I have changed MySQL 8 on my Windows 10 development machine to write logfiles (general log and slow queries log) to "E:\mysql logfiles". I'd like to compress this directory using the Windows ...
Nzall's user avatar
  • 221
0 votes
1 answer
517 views

How to deploy install of MS SQL Server 2017 Developer Edition via command-line script - not working

I'm trying to deploy MS SQL Server 2017 Developer Edition via command-line script from a server share that holds the install media onto Windows 10 1803 (June release). However, I'm not having much ...
cmc.tech's user avatar
0 votes
1 answer
356 views

Issue with 2016 developer edition install

Issue with 2016 developer edition install on new windows 10 machine. Not finding any docs or similar issues posted. An error occurred for a dependency of the feature causing the setup process for ...
Matt Sharkey's user avatar
0 votes
1 answer
1k views

MariaDB not starting in windows 10 after crash

MariaDB 10.7 service suddenly stopped in Windows 10 after a crash and the service is not starting. The pop up shows 'windows cannot start mariadb service). The windows event viewer gives the following ...
sariDon's user avatar
  • 111
0 votes
1 answer
3k views

Connect to WSL2 Postgres database from local network

I run Postgres 12 service in Windows Subsystem for Linux 2 (WSL2). In my /etc/postgresql/12/main/postgresql.conf, I have: listen_addresses = '*' while my /etc/postgresql/12/main/pg_hba.conf has this ...
vlad's user avatar
  • 103