Windows 10: What component of I/O subsystem caused database corruption in my SQL Server

As per Error 824 that has occurred in my SQL error Log, I have found that the I/O subsystem is the cause of the database corruption.Error 824However, I want to dig further and understand which specific component of the I/O subsystem caused the corruption.Is there a methodology to identify this? How can I find out which component of I/O has caused the corruption to my database?Additionally, I have found information on how to check which component of the I/O subsystem has caused latency in the link below.I/O Latency However, this does not address whether I/O subsystem latency causes databa

:)

 

SQL Server 2017 Express Issue with 3 Tier database access.

Hi, I am facing an issue with SQL Server 2017 Express.

My client is on PC1, SQL server is configured on PC2 and the database is on PC3. I could successfully connect to SQL server on PC2 through client on PC1, but if I try to access the database on PC 3 using client on PC1, I get following error...

"Msg 5120, Level 16, State 101, Line 2

Unable to open the physical file "\\MD1Z549C.ad001.siemens.net\Database_DT\Products\ProductDB.mdf". Operating system error 5: "5(Access is denied.)".

Msg 1802, Level 16, State 7, Line 2

CREATE DATABASE failed. Some file names listed could not be created. Check related errors."

When i access the database on PC2 there is no Issue. or if i use other SQL server from PC1 then I could access database database on PC3 as well. (here no intermediate PC2 is used)

So issue is when I have Client, SQL Server and Database on 3 different machines. (it gives above errro message)

The same scenario used to work well with SQL server 2008 R2 Express.

The same issue is reproducible with SQL server 2017 full version and SQL server 2019.

All the three PCs, shared drives and SQL server are configured well, which used to work with SQL server 2008 R2 express.

Is there any limitation or restriction introduced with the latest version of SQL server ? OR anything I need to try out to make the scenario work on three different machine.

Thanks a lot in advance.

 

SQL server 2016 database audit specification problem

I install Sql server 2016 on standard mode.

now I want to configuration on auditing on SQL server database. I enable audit and server audit specification.

But I can not create database audit specification........

How can i do this ......

it shows that, this audit is not available for that sql server.

 

Always Encrypted now generally available in Azure SQL Database

Source: Always Encrypted now generally available in Azure SQL Database | Blog | Microsoft Azure