SqlServer, unable to retrieve data for this request, try to open or create a physical file, CR

Recently, MSSqlServer was installed on the system, but an error was reported when the database was attached. An error code 5123 is reported, indicating that data cannot be retrieved for the request. CREATEFILE encounters an operating system error 5 (Access denied) when trying to open or create a physical file ). When I saw this error, I thought that the permission was insufficient.

Recently, MSSqlServer was installed on the system, but an error was reported when the database was attached. An error code 5123 is reported, indicating that data cannot be retrieved for the request. If you attempt to open or CREATE a physical FILE, create file encounters an operating system error 5 (Access denied ). When I saw this error, I thought that the permission was insufficient.

Recently, MSSqlServer was installed on the system, but an error was reported when the database was attached.

An error code 5123 is reported, indicating that data cannot be retrieved for the request. If you attempt to open or CREATE a physical FILE, create file encounters an operating system error 5 (Access denied ).

When I saw this error, I thought that the permission was insufficient. So I changed the permissions of the folder where the database is located.

Right-click the folder, select Properties, find the Security tab, edit the permissions of the current user, and set it to full control.

However, an error is reported.

I want to modify the permissions of the hard disk partition where the database is located. After modification, I still cannot.

Will it be a problem with MSSqlServer's startup account? modify it again. It's done.

Open "Run (shortcut: win + R)" And enter services. msc, open the service window, find the SQL Server (MSSQLSERVER) service, right-click Properties, select login, change the login identity to a local system account, and then restart the service.