Plain Text Password in Maintenance Plans
The user and password of the user that create a Maintenance Plans using the MSSMS is save in plain text, you can use the following query to access this informaci�n.
SELECT CAST(CAST(packagedata AS VARBINARY(max)) AS VARCHAR(max)) FROM sysssispackages
WHERE name LIKE 'MaintenancePlansName'
This will show the xml of Maintenance Plans including the user and password.
We’ll investigate this, but currently do not have any concrete plans for a fix.