Friday, March 9, 2012

Fail to save Maintenace Plan using 'sa' with blank password

sa with no password is not exactly supported (for reasons which should be
obvious). What is your business need to leave this password blank?
"Michael Bergman" <simutek@.community.nospam> wrote in message
news:B90366AD-B401-43EA-AA3E-3A86939AABF2@.microsoft.com...
> Is it not supported to create a Maintenance Plan when logged in as 'sa'
> with
> blank password in SQL Server Management Studio?
> When logged in as 'sa' I get the following error when trying to save a
> Maintenance Plan:
> One or more arguments are invalid
> But if I login using Windows Authentication, or add a password to 'sa', I
> can successfully save a Maintenance Plan. I am using SQL Server 2005 SP1
> with
> Integration Services installed.
> --
> Regards,
> Michael Bergman
> SIMUTEK AB
>
This was an issue for one of our customers. We recommend strong passwords.
However, some customers still use blank password from old habit.
Now that I have confirmed that creating Maintenance Plans using blank
password is not supported, this might encourage our customers to change to a
strong password.
Regards,
Michael Bergman
SIMUTEK AB
"Aaron Bertrand [MVP]" wrote:

> sa with no password is not exactly supported (for reasons which should be
> obvious). What is your business need to leave this password blank?
>
>
> "Michael Bergman" <simutek@.community.nospam> wrote in message
> news:B90366AD-B401-43EA-AA3E-3A86939AABF2@.microsoft.com...
>
>

No comments:

Post a Comment