Bring online database (access denied) Microsoft SQL Server 2012 BI – Accesso negato mettendo online un database

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:

  1. right click on .mdf file --> Properties --> Security -- Edit --> Add
  2. 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.