Users are not listed or missing in the Database Connection Viewer in Blackbaud Hosting Services

The Database Connection Viewer does not show the names of users logged into the database. Users can see the computer name or Blackbaud Hosting Services application server name in the Database User column, but only one user name will appear in the Username column. The name that appears will typically be the username that the user is logged in with.
The Database Connection Viewer outputs a variety of information on the users connected to your database. Please review this article to determine the different connection information and data points displayed in this plugin.

This tool was intended for use by locally installed Blackbaud solutions where users are connected to a single SQL server instance. For customers whose database is hosted by Blackbaud, we recommend you not use this feature as an accurate depiction of connections in the database. Blackbaud users from the same organization can be logged into different application servers to access the same database. The utility cannot view or access all servers to see who is logged in at any given time and may not display accurate number of connections.
 

Environment

 SQL Server 2008 R2 Express;SQL Server 2008 R2

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.