Knowledge Essentials - 3Essentials Hosting

MSSQL Guest account enabled

Article ID: 698

 Back to Search

You're seeing other users databases in the db admin tool because those users (against security best practices) have enabled a GUEST user account on their database. As such, you can SEE it via the db admin... however, should also notice that you can't actually access the databases, to browse/view/modify data.

To prevent your db from being seen like this from other users, do not create a GUEST user for your database. Usually the way this occurs is that you created the database on your system, which guest access... then if you uploaded a backup of that db for us to restore, the guest access was then created on the database on our system (from the user's restored db).
 
Downloads Associated With This Article
No downloads are currently associated with this article.