Questions tagged [windows-10]
The windows-10 tag has no usage guidance.
72
questions
21
votes
6
answers
70k
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 ...
- 441
13
votes
3
answers
27k
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
...
- 133
13
votes
1
answer
5k
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 ...
- 251
10
votes
2
answers
80k
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 ...
- 113
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 ...
- 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 ...
- 183
4
votes
2
answers
6k
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-...
- 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 ...
- 149
4
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....
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 ...
- 602
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 ...
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. ...
- 191
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 ...
- 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 ...
- 135
2
votes
1
answer
9k
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 ...
- 143
2
votes
1
answer
4k
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? ...
- 121
2
votes
0
answers
367
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 ...
- 435
2
votes
1
answer
829
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 ...
- 1,342
1
vote
3
answers
986
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 ...
- 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) ...
- 1,349
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 ...
- 133
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 ...
- 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 ...
1
vote
1
answer
434
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 ...
- 157
1
vote
1
answer
5k
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 ...
- 111
1
vote
2
answers
6k
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 ...
- 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: ...
- 11
1
vote
0
answers
14
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 ...
- 1,027
1
vote
0
answers
266
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 ...
- 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 ...
- 121
1
vote
0
answers
968
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 ...
- 11
1
vote
0
answers
67
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 ...
- 11
1
vote
0
answers
672
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")
...
- 121
1
vote
0
answers
728
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 ...
- 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 ...
- 111
1
vote
1
answer
18k
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, ...
1
vote
0
answers
116
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 ...
- 11
1
vote
1
answer
440
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 ...
- 11
1
vote
1
answer
419
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 ...
- 111
0
votes
1
answer
198
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. ...
- 103
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 ?...
0
votes
1
answer
4k
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 ...
- 13
0
votes
2
answers
2k
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:/...
- 131
0
votes
1
answer
2k
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 ...
- 121
0
votes
2
answers
118
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 ...
- 101
0
votes
1
answer
25
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 ...
- 221
0
votes
1
answer
482
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 ...
- 3
0
votes
1
answer
336
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 ...
- 21
0
votes
1
answer
387
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 ...
- 111
0
votes
1
answer
2k
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 ...
- 103