Skip to content
Tech Shizz Logo

An Engineers Blog

  • TechShizz
  • blog

Microsoft SQL Error 5123 when trying to attach a SQL database

Posted on February 23, 2021 By rich No Comments on Microsoft SQL Error 5123 when trying to attach a SQL database

I had this error when trying to attach a SQL database. You may also get “error 1813”
“Failed to retrieve data for this request. (Microsoft.SqlServer.Managment.Sdk.Sfc)
Additional Information
-> An Exception occured while a Transact-SQL statment or batch.
(Microsoft.SqlServer.ConnectionInfo)
-> CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file C:Databasename.mdf. (Microsoft SQL Server, Error: 5123)

This error is a permissions error.
1. Ensure the database has the SQL service account in its ACL. This user is called MSSQLSERVER by default. You can place the database in the below folder and it will inherit the permission
C:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATA

2. Ensure you run the SQL Managment Studio as Administrator.

Post navigation

❮ Previous Post: SQL: Create Tables
Next Post: HTTP Error 500.19 with Error Code 0x8007007E ❯

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to our newsletter!

Recent Posts

  • How to implement a lightning-fast ransomware playbook
  • How to achieve defence in depth in your business
  • How to implement a SecOps team phishing response plan
  • How to block an Office 365 Sign-in correctly
  • Microsoft finally patched serious Exchange 0-day over a month old!

Recent Comments

    Archives

    • November 2022
    • July 2021
    • March 2021
    • February 2021

    Categories

    • Cyber Security
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Copyright © 2023 .

    Theme: Oceanly News Dark by ScriptsTown