24 votes

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

Every time I reboot windows, for some databases comes out this error. (OS Error 21 - Device not ready) This is due to a disk being offline or not being online either at the time SQL Server started, ...
Sean Gallardy's user avatar
23 votes

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

Had the same error. Turns out that it was my setting in Region -> Formats -> Format. When it was on English (World) or English (Europe), I would get this error. Setting it to English (United States) ...
d.hernandez's user avatar
14 votes

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

I think I've found the cause. Most likely the problem is due to "Fast startup" power options. It'a a Windows technique to reduce the boot time; Fast Startup combines elements of a cold shutdown and ...
Max's user avatar
  • 471
13 votes
Accepted

PostgreSQL 9.5 won't start after Windows 10 fall update

Thanks to suggestion from Daniel Vérité I was able to fix it without dumping the entire db server. My understanding of locales on Windows is very limited but from what I've learned it seems like ...
jvb's user avatar
  • 261
6 votes
Accepted

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

I think 3072 (0x0c00) is an invalid locale ID, at least according to this. So this looks like a corrupted Windows installation, perhaps from a flaky disk (eg. a byte overwrite of a locale 0x0c1a, ...
Remus Rusanu's user avatar
  • 51.9k
5 votes
Accepted

SSMS crashes when attempting to create a database diagram

I've found that the database diagram tool seems to crash if you modify things outside of the diagram. Diagrams appear to remain stable if: The database diagram tool is used to do all of your ...
Paul's user avatar
  • 188
5 votes
Accepted

SQL Server 2016 Plugin's not working

Vendors will need to catch up, as the add-in model and API have changed. This will lead to better extensibility, but for now you'll need to wait for the vendors to do this work. There is usually not ...
Aaron Bertrand's user avatar
5 votes

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

This problem has irritated me as well. I have 5 dbs hooked onto my SQL Server instance, 3 of which are working fine, but 2 of which complains The operating system returned error 21(The device is not ...
Ji_in_coding's user avatar
5 votes

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

These are my observations and how I solved the problem (for the benefit of others who may have the same problem) I was using amazon ec2 instance running Sql server. I had an EBS Block device attached ...
VenVig's user avatar
  • 111
4 votes

Practicing AlwaysOn on SQL Server 2014 - Windows 10 Home

SQL Server 2016 will allow for Availability Groups without a domain, but sorry, I don't think your operating system is going to cut it. To support your scenario, you could put an eval of a proper ...
Aaron Bertrand's user avatar
4 votes
Accepted

SQL Server 2005 error after update to windows 10

Unfortunately (regarding your problem) Microsoft is pretty clear about your situation on this SQL Server 2005 information doc: This section provides support information about instances of SQL Server ...
Ronaldo's user avatar
  • 5,079
3 votes

Can't install Oracle 11g

Oracle Database 12.1.0.2 is the first version that is certified on Windows 10. Oracle Database 11.2 is not certified on Windows 10. Just click Yes and continue. By the way, the 11.2.0.4 installer ...
Balazs Papp's user avatar
  • 40.7k
3 votes

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

You can set the service property to restart it (service properties --> recovery --> first / second / third failure and have a delay between each restarts e.g. 1 min). You should also, have the service ...
Kin Shah's user avatar
  • 62.2k
3 votes
Accepted

Is Windows 10 compatible with SQL Server 2014 Developer MDS?

I think it is fine; the documentation was just written long before Windows 10 was released and hasn't been updated (I've sent in a note that it should be corrected). In fact it is listed as fully ...
Aaron Bertrand's user avatar
3 votes

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

@LaurenzAlbe comment made it. He deserves all the credit, but I am posting the answer with commands output in case somebody has the same issue and it could help. First, running initdb.exe : C:\Program ...
nephewtom's user avatar
  • 151
2 votes

Practicing AlwaysOn on SQL Server 2014 - Windows 10 Home

You can use Microsoft's Virtual Labs to practice : Virtual labs enable you to quickly evaluate and test Microsoft's newest products and technologies through a series of guided, hands-on labs that you ...
Kin Shah's user avatar
  • 62.2k
2 votes

Issue with 2016 developer edition install

Given this image, I can imagine you are selecting to install every single feature during setup: I would start with just the set of features you need, since selecting everything - especially if ...
Aaron Bertrand's user avatar
2 votes

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

Found this post after doing some research on SQL ODBC drivers for a business user today and wanted to clarify. The SQL native client is not supported beyond 2012. The new hotness (in your case) is the ...
warren2600's user avatar
2 votes

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

The full error I got when connecting to my local default MS SQL instance (2017) via MSSMS is: The operating system returned error 21(The device is not ready.) to SQL Server during a read at ...
Thierry_S's user avatar
  • 121
2 votes

Can't restart Postgres on Windows 10 with external drive

What type of partitioning scheme and USB chipset (USB-sata bridge) does the drive use? There are all sorts of unexpected limits you can still hit on a modern USB drive with certain partition types/...
SpliFF's user avatar
  • 121
2 votes
Accepted

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

In the error is states the reason which seems fairly self-explanatory: You have selected a feature that is not supported for Windows Server Core... [Features Supported] One of your input arguments ...
Sean Gallardy's user avatar
2 votes

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

When you launch your app using "runas" command, you use some domain user, and that user has Windows login at your SQL server. Or that domain user is part of some AD group that has Windows login at ...
Aleksey Vitsko's user avatar
2 votes

What should I do about PostgreSQL logging so much "weird noise" in its own log?

All of these messages are relevant, and the fact that your application doesn't log them has no impact on that. LOG: could not receive data from client: That means that your application (or a ...
Laurenz Albe's user avatar
  • 51.6k
2 votes

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

The Windows feature to compress a directory is transparent to all applications. However, it does slow down I/O operations some. The General Log should not be left on forever; it is a big disk hog. ...
Rick James's user avatar
  • 78.1k
2 votes

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

do I need a DC? No you can use SQL Authentication, or Windows Auth (NTLM) with "workgroup auth". And to use a DC you would have to join both of your boxes to the domain, so I wouldn't ...
David Browne - Microsoft's user avatar
2 votes
Accepted

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

Was able to get back the data. Step 1: Move all the file from mysql/data directory to data_old directory except mysql and performance_schema directory. Step 2: Copy back the ibdata1 file from backed ...
Sourav's user avatar
  • 121
2 votes
Accepted

How to restore one mysql database with mysqldump

You do not use mysqldump to reload a database dump. You reload with the mysql client. See my old post Is it possible to mysqldump a subset of a database required to reproduce a query? for example. I ...
RolandoMySQLDBA's user avatar
1 vote
Accepted

pgAgent service for PostgreSQL does not run

I'm not sure what I did, but I have the service running now. I guess it is a combination of little of everything Open CMD as administrator browse to pgagent.exe cd C:\Program Files\PostgreSQL\...
tomatoeshift's user avatar
1 vote

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

A humble advice from a beginner. I recommend starting with pgAdmin on Windows to understand whether you have a basic mistake here or not. Install the recent version of pgAdmin. Then create a new ...
questionto42's user avatar
1 vote

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 believe that PowerBI uses npgsql to connect, which defaults to the behavior that libpq/psql gives you under 'PGSSLMODE=verify-full'. Can you connect to your server from Windows psql if you use '...
jjanes's user avatar
  • 39.8k

Only top scored, non community-wiki answers of a minimum length are eligible