15 Nov’19

Blog, OthersHow to resolve error when attaching a database in SQL Server

Introduction:

One of the common Errors while attaching a .mdf file for restoring Data is as follows:

An error occurred when attaching the database(s).  Click the hyperlink in the Message column for details.

The detailed message is as follows.

Step 1:

Right, Click on the .mdf that you want to attach and click on Properties.

Step 2:

Go to Security tab and give Full Control to all Users and Groups by clicking on Edit.

Click on the Check Box under Allow section for Giving Full Control to all Users and Groups.

Step 3:

Right-click on the Main Folder containing your .mdf file and go to the properties section.

Deselect the  “Read Only Option” in “General Tab” and click on Apply.

Step 4:

Go to the “Security Tab” and give “Full Control” to all “Groups and User Names” as shown in Step 2 and click on Apply.

Select “Apply changes to this folder, subfolder and files” option and click on “Ok”.

Click on “Ok” to apply all the changes.

Step 5:

Now go to SQL and Attach your .mdf file Again and your DB will be attached to the Databases folder and you can access it.

Check out my other blog here https://www.cloudfronts.com/performing-update-operation-in-microsoft-dynamics-nav-through-integration-in-scribe-online/

 

Written by

Rushank Karekar

Software Engineer

Leave a Reply

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

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • How to create Dynamics 365 Finance & Operations (formerly Dynamics AX) connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during the integration of data. While performing Integrati...

    Read more
  • How to create AX (D365 F&0) Connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during integration of data. While performing Integration w...

    Read more
  • First cut review of new D365 Project Service

    12 December’ 2019

    The new Project Service coming up is a much-advanced version of PSA. Even more, than it will be called as Project Servic...

    Read more
  • Business Central Wave 2 Features – Section 4

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more
  • Business Central Wave 2 Features – Section 5

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close