Try the following in the order listed until the issue is resolved:
  1. If using Mixed Mode Authentication in SQL Server (SQL Server and Windows Authentication), detach the database and re-attach the database
  2. If using Windows Authentication in SQL Server:  Grant View Server State Privileges for your Windows users or switch to Mixed Mode Authentication in SQL Server