Forum Discussion
Attach/Detach sql server database
I had sql server 2014 installed in my pc on hard drive c:. But then I wanted to improve the pc performance by installing an ssd drive instead of the physical hard drive without taking the precaution ...
You still didn't provide any usefull information and also not the error message; it's impossible to assist you.
As you have mentioned you are facing an error 5123, There are 2 steps to attach your database if you are not able to do that.
Granting permissions: You need to right-click on properties and then under properties select security and edit on permissions and provide the full control access by selecting allow in full control.
Try attaching the database in SQL Server using any of the following methods:
1) BY SSMS: By adding in SSMS
2) By T SQL
Granting permissions: You need to right-click on properties and then under properties select security and edit on permissions and provide the full control access by selecting allow in full control.
Try attaching the database in SQL Server using any of the following methods:
1) BY SSMS: By adding in SSMS
2) By T SQL