Database files or folder(s) are not visible or do not appear when attaching or restoring a database using the Blackbaud Management Console

When using the Attach a Database wizard in the Blackbaud Management Console to attach or restore a database, you may experience the following:
  • No database files are visible or show when browsing to and attaching a database using the Blackbaud Management Console (BMC).
  • No folder(s) show when trying to browse to select the database file when using the Attach a Database wizard.
Please complete each of the following steps in order until the issue is resolved:
  1. Ensure that the Windows account you're logged onto the Blackbaud Management Console with has sysadmin rights to the SQL Server instance you're wanting to use to.
  2. Determine what account is running the SQL Server service and grant it Full Control permissions to the database folder(s) and files. To locate the account that is running the SQL Server service:
  • Click Start
  • Type services.msc and press Enter
  • In the window that launches, scroll down to locate the service titled SQL Server (INSTANCE NAME) 
  • Scroll to the right to find the name of the account listed under the column "Log On As".
  1. Should issues persist with browsing to the database after the above steps have been completed, then verify that xp_cmdshell is enabled.

Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.
 
If using SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 or SQL Server 2014:
  1. Connect to your SQL Server instance using SQL Server Management Studio.
  2. Right-click on the SQL Server instance and select Facets.
  3. In the Facet drop-down list, select Surface Area Configuration.
     

    image showing the Surface Area Configuration selection 

  4. For the XPCmdShellEnabled property, select True in the drop-down list and click OK.
  5. Open the Blackbaud Management Console and attach the database to your SQL Server instance.
For more information, refer to Understanding Surface Area Configuration in the Microsoft Knowledgebase. 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.




 

Environment

 SQL Server 2008;SQL Server 2008 R2;SQL Server 2012;SQL Server 2014

Was this article helpful?