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