We are about to start a migration and one of the requirements from the scrip
t
is to have both sa passwords set to blank (no password) while the migration
takes place. Where do I go to change the SA password on a sql 2000 server an
d
a sql 7.0 server?
My expertise isn't in SQL so any steps would be very helpful!
Thanks!!!"Candie" <Candie@.discussions.microsoft.com> wrote in message
news:1A4D7D3E-2075-4D88-97C0-B192663943FB@.microsoft.com...
> We are about to start a migration and one of the requirements from the
> script
> is to have both sa passwords set to blank (no password) while the
> migration
> takes place. Where do I go to change the SA password on a sql 2000 server
> and
> a sql 7.0 server?
> My expertise isn't in SQL so any steps would be very helpful!
> Thanks!!!
SQL Enterprise Manager -> Security
Pick the sa login and change the password.
Rick Sawtell
MCT, MCSD, MCDBA|||Query Analyzer works.
exec sp_password
Read about it within Books Online (within the SQL Server program group).
Keith
"Candie" <Candie@.discussions.microsoft.com> wrote in message
news:1A4D7D3E-2075-4D88-97C0-B192663943FB@.microsoft.com...
> We are about to start a migration and one of the requirements from the
script
> is to have both sa passwords set to blank (no password) while the
migration
> takes place. Where do I go to change the SA password on a sql 2000 server
and
> a sql 7.0 server?
> My expertise isn't in SQL so any steps would be very helpful!
> Thanks!!!|||"Candie" <Candie@.discussions.microsoft.com> wrote in message
news:1A4D7D3E-2075-4D88-97C0-B192663943FB@.microsoft.com...
> We are about to start a migration and one of the requirements from the
script
> is to have both sa passwords set to blank (no password) while the
migration
> takes place.
Huh? I'd really question WHY?
In any case if you do this, make darn sure you have the machines isolated
from the Internet via a firewall or something. A number of exploits exist
that look for and exploit blank passwords.
> Where do I go to change the SA password on a sql 2000 server and
> a sql 7.0 server?
> My expertise isn't in SQL so any steps would be very helpful!
> Thanks!!!
No comments:
Post a Comment