Symptoms when the guest user is disabled in the msdb database
USE msdb;
SELECT prins.name AS grantee_name, perms.*
FROM sys.database_permissions AS perms
JOIN sys.database_principals AS prins
ON perms.grantee_principal_id = prins.principal_id
WHERE prins.name = 'guest' AND perms.permission_name = 'CONNECT';
GO
If you receive a result set that resembles the following, the guest user has the necessary permissions.
How to resolve the issue
USE msdb;
GRANT connect TO guest;
GO
http://support.microsoft.com/kb/2539091/en-us
No comments:
Post a Comment