Cannot attach databases due to "access denied" errors

  1. Make sure you are running SQL Management Studio as an administrator. You can do this by right-clicking the icon and selecting "Run as Administrator."
  2. Make sure the file permissions on the database folders are correct. Specifically, the following directory needs to give modify access to the service account user:

    C:\Program Files (x86)\ASEBA\ASEBA-Network\2015\wwwroot\App_Data\Databases

To get the name of the service account user, run the following command in SQL Server Management Studio:

SELECT servicename, service_account FROM sys.dm_server_services

 
 

 

Comments are closed