Guest account in MSDB and service broker

When I revoke Guest user in  Msdb, application team start complaining saying their application cannot be use to change user account password and return error below.

ERR:javax.ejb.EJBException: java.lang.RuntimeException: java.sql.SQLException: Server level event notifications are disabled as the database MSDB does not exist.
java.sql.SQLException: Server level event notifications are disabled as the database MSDB does not exist.

again when I grant connect to guest, application run flawlessly, now the point is I don't get where the relation between change password and use of this event notification in sql ?
motioneyeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Scott PletcherConnect With a Mentor Senior DBACommented:
"Guest" account is automatically used by SQL Server itself in master and msdb (at least) for certain specific things.  You're never supposed to disable guest in either of those system dbs (at least).  You can disable guest in any user db, if you want to.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.