What NTFS permissions are modified when detaching a database from SQL Server in the Blackbaud Management Console?

When you detach a database from SQL Server in the Blackbaud Management Console (BMC), what NTFS permissions are modified on the database files?
After detaching a database from SQL Server in the Blackbaud Management Console (BMC), the NTFS permissions on the database files are modified so that only the Windows user who detached the database has rights to re-attach them. Other Windows users may not be able to re-attach these files even if they have local administrator rights and sysadmin rights to the SQL Server instance.  The modification of these NTFS rights are not caused by or specific to the use of the Blackbaud Management Console, but instead is typical behavior for Microsoft's SQL Server when detaching a database. Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist with implementing resolutions from these websites.

As a result of these rights being modified, you may receive the error "Is detached primaryFile failed for Server [SQL Server Instance]" when attempting to attach. To resolve this error, a Windows account that has local administrator rights on the SQL Server server will need to grant full control permissions to the database files for the Windows account that needs to attach the files and the SQL Server Service Account

Environment

 SQL Server 2008 Express;SQL Server 2008;SQL Server 2008 R2 Express;SQL Server 2008 R2;SQL Server 2012 Express;SQL Server 2012;SQL Server 2014 Express;SQL Server 2014;SQL Server 2016

Was this article helpful?