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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.