Shulou(Shulou.com)05/31 Report--

This article will explain in detail what to do about the failure of attaching to the SQL Server database. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

1. Error 3415

Problem: when attaching a database, it is found that the attachment always fails. When viewing the message, the problem is found as follows:

After viewing the message, it is found that the error code is 3415: the database file is a read-only solution: remove the read-only attribute from the file properties.

2. Error 5120

Problem: after solving error 3415, there is still an error in the attached database. When viewing the message, the problem is found as follows:

Check the message and find that the error code is 5120 solution 1 (try): change the database login method to Windows authentication, and then try again; solution 2: check the properties of the database file-> security label, and find

A user group for Everyone should be added here

And then give full control.

Attach it again and you can succeed.

This is the end of this article on "what to do with the failure of SQL Server database attachment". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.