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

16 Nov 2006 6:30 PM

Michael Bergman

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

16 Nov 2006 11:01 PM

Aaron Bertrand [MVP]

sa with no password is not exactly supported (for reasons which should be
obvious). What is your business need to leave this password blank?

Show quote

"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
>

17 Nov 2006 8:54 AM

Michael Bergman

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

Show quote

"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...
> > 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
> >
>
>
>