Guest user in the MSDB database in SQL Server

Views 697

SQL Server Books On Line (BOL) recommends that you disable the guest user in every Database as a best practice for securing the database server. Microsoft on 28th April 2011 release KB article 2539091 outlining a change to this recommendation.

This KB article suggests that you DO NOT disable this user due to some Microsoft SQL Server features will not work. The error message that you receive may vary slightly but the underlying cause is insufficient privileges in the MSDB database.

For further information on the 3 symptoms identified by Microsoft read the KB article 2539091 to ensure this relates to the issue that you are experiencing. The end result is to Grant Connect permissions to Guest in the MSDB database.

I hope this helps all of you.

Warwick

I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.

Search
0

Your Cart