Server Status appears as Unknown after attaching database with port specified.

After attaching a database to the Blackbaud Management Console, if the database was attached by specifying both instance name and the specific port that instance is using, the status for that server will be listed as unknown in the Blackbaud Management Console.  This will prevent the Blackbaud Management Console from viewing if the service is started and also prevent the Blackbaud Management Console from being able to start or stop the service.

We have found that this issue occurs when specifying the instance name and port number the status will be listed as unknown. To resolve users can detach the database and reattach without specifying the instance name and port number.

We have evaluated this as an issue with the Blackbaud Management Console and we have determined it will not be addressed in the program in its current state.  In this case, we believe the risks and challenges outweigh the potential benefit of resolving this issue. We strive to select the most impactful changes and issues to address with each release to accelerate the rate at which we deliver new features while sustaining the highest level of quality for our customers.

Steps to Duplicate

1.  Open Blackbaud Management Console.
2.  Start Attach Database Wizard.
3.  When selecting SQL instance, specify the servername and port of the SQL instance using the standard servername,portnumber nomenclature.
4.  Continue attach database wizard as normal.
5.  After database is attached, click on the SQL instance under Servers in the left-hand pane. Status will be unknown.


 Raiser's Edge

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.