Problem:
If you try to bring online a database and you receive “access denied” probably it’s possible, if you are an administrator with grant rights, that .mdf file doesn’t have right permissions.
In my case the problem was NT Service/MSSQLSERVER or NT Service/MSSQLSERVER$IstanceName
Solution:
right click on .mdf file --> Properties --> Security -- Edit --> Add
Search NT Service/MSSQLSERVER or NT Service/MSSQLSERVER$IstanceName add in Full Control permission.
Well done!
Best Regards,
ITquadro – specialized Blog
ITquadro sistemisti specializzati su Bologna ed Emilia-Romagna esperti in installazione e configurazione di Microsoft SQL Server 2012 / 2008 R2 e troubleshooting, ecc.