Skip to Content

[Solved] How to Fix Database Access Denied Error 5123 happen on SQL Server 2008 R2

Problem: Error 5123 is displayed when you’re trying to attach a database in SQL Server 2008 R2 that was previously detached by another user with a different login.

CREATE FILE encountered operating system error 5 (Access is denied) while attempting to open or create the physical file… (Microsoft SQL Server, Error 5123)

SQL Server 2008 R2 Database error 5123

Solution

Step 1: In the Security tab of the Properties dialog, selected OWNER RIGHTS in the “Group or user names” section, the listed permissions were empty for both Allow and Deny.

Step 2: Click on Advanced and, from that view, OWNER RIGHTS had all permissions checked.

Step 3: Click Edit and ensure that all check boxes are set for Allow.

Database Security tab

Reference

Database Attach Failure in SQL Server 2008 R2
SQL SERVER – FIX: Msg 5123, Level 16 – CREATE FILE Encountered Operating System Error 5
How to Fix SQL Server 2008 R2 Database Error 5123
How to Resolve Microsoft SQL Server Error 824 Manually?

    Ads Blocker Image Powered by Code Help Pro

    Ads Blocker Detected!!!

    This site depends on revenue from ad impressions to survive. If you find this site valuable, please consider disabling your ad blocker.