I'm running MBSA 2.1 on a fully patched SQL Server 2005 and getting these two
results, which I don't understand:
SSIS Roles -- No permissions to access database.
This check determines if the BuiltIn Admin is part of db_DTSAdmin,
db_DTSltduser or db_dtsoperator roles.
Sysdtslog -- No permissions to access database.
This check determines if the Sysdtslog90 table exists in the Master and
MSDB databases.
Clicking "How to correct this" just returns a generic "How to Correct Common
Errors" link.
My first question is, does "No permissions to access database" mean:
1. Everyone can access the database because there are no permissions
2. No none can access the database because there are no permissions
I would think that based on "Secure By Default" that it should be #1.
The next question is: Since SSIS isn't installed, why does it care about the
roles?
My third question is, "How do I fix whatever MBSA is flagging?"