Changing SA password to "blank" (null)

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

Changing SA password to "blank" (null)

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

Changing SA password to "blank" (null)

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

changing passwords

I'm new on a project and need to change all web users passwords. Were would you start from Enterprise Manager?Are you talking about logging in to sql server?

I wouldn't think so...if it's a web app you're probably pooling...

Do they applcaition level security?

Do you use NT security (not for web users )

What's you're security model?|||Thanks for reply. It appears the last person in my spot did'nt follow any name convention that I see. Someone returned today from Thanksgiving vacation who show a strange table named then it made since. I was able to make the changes and get up & Runing.

Thanks
Originally posted by Brett Kaiser
Are you talking about logging in to sql server?

I wouldn't think so...if it's a web app you're probably pooling...

Do they applcaition level security?

Do you use NT security (not for web users )

What's you're security model?

Changing NT Passwords used by SQL Server

Dear All,
Our Server department would like to change the passwords
of our Domain User accounts used by SQL Server and SQL
Server Agent Accounts.
Can anyone tell me the impact of this and whether we need
to do anything at the SQL end.
Regards
Peter
Hi,
After changing the password of the domain os user account, you need to
change the password entry in
control panel -- Admin tools -- services -- MSSQL server (double click
miuse) -- go to "Log on" tab-- type the new password and restart the MSSQL
server service
Do the same for SQL Agent service as well.
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> Dear All,
> Our Server department would like to change the passwords
> of our Domain User accounts used by SQL Server and SQL
> Server Agent Accounts.
> Can anyone tell me the impact of this and whether we need
> to do anything at the SQL end.
> Regards
> Peter
|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:#hkuRfBYEHA.2944@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After changing the password of the domain os user account, you need to
> change the password entry in
> control panel -- Admin tools -- services -- MSSQL server (double click
> miuse) -- go to "Log on" tab-- type the new password and restart the
MSSQL
> server service
I am not completely sure but I do not think that you have to restart
MSSQL server service.

> Do the same for SQL Agent service as well.
>
> --
> Thanks
> Hari
> MCDBA
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:2511801c46015$9f076c20$a401280a@.phx.gbl...
>
|||To get to the SQL AGent login in SEM right click SQL Agent and go to
properties...
I have heard of an issue with changing the password on the full text index
search service, that requires special attention, but I do not remember the
details... It seems like as long as you set the login/password via SEM
things worked, but if you did it via windows services, there was a
disconnect somehow... You might want to google it.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> Dear All,
> Our Server department would like to change the passwords
> of our Domain User accounts used by SQL Server and SQL
> Server Agent Accounts.
> Can anyone tell me the impact of this and whether we need
> to do anything at the SQL end.
> Regards
> Peter
|||Thanks for all your responses, you have told me what I
need to know.
Peter

>--Original Message--
>Dear All,
>Our Server department would like to change the passwords
>of our Domain User accounts used by SQL Server and SQL
>Server Agent Accounts.
>Can anyone tell me the impact of this and whether we need
>to do anything at the SQL end.
>Regards
>Peter
>.
>

Changing NT Passwords used by SQL Server

Dear All,
Our Server department would like to change the passwords
of our Domain User accounts used by SQL Server and SQL
Server Agent Accounts.
Can anyone tell me the impact of this and whether we need
to do anything at the SQL end.
Regards
PeterHi,
After changing the password of the domain os user account, you need to
change the password entry in
control panel -- Admin tools -- services -- MSSQL server (double click
miuse) -- go to "Log on" tab-- type the new password and restart the MSSQL
server service
Do the same for SQL Agent service as well.
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> Dear All,
> Our Server department would like to change the passwords
> of our Domain User accounts used by SQL Server and SQL
> Server Agent Accounts.
> Can anyone tell me the impact of this and whether we need
> to do anything at the SQL end.
> Regards
> Peter|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:#hkuRfBYEHA.2944@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After changing the password of the domain os user account, you need to
> change the password entry in
> control panel -- Admin tools -- services -- MSSQL server (double click
> miuse) -- go to "Log on" tab-- type the new password and restart the
MSSQL
> server service
I am not completely sure but I do not think that you have to restart
MSSQL server service.
> Do the same for SQL Agent service as well.
>
> --
> Thanks
> Hari
> MCDBA
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> > Dear All,
> > Our Server department would like to change the passwords
> > of our Domain User accounts used by SQL Server and SQL
> > Server Agent Accounts.
> >
> > Can anyone tell me the impact of this and whether we need
> > to do anything at the SQL end.
> >
> > Regards
> > Peter
>|||To get to the SQL AGent login in SEM right click SQL Agent and go to
properties...
I have heard of an issue with changing the password on the full text index
search service, that requires special attention, but I do not remember the
details... It seems like as long as you set the login/password via SEM
things worked, but if you did it via windows services, there was a
disconnect somehow... You might want to google it.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> Dear All,
> Our Server department would like to change the passwords
> of our Domain User accounts used by SQL Server and SQL
> Server Agent Accounts.
> Can anyone tell me the impact of this and whether we need
> to do anything at the SQL end.
> Regards
> Peter|||Thanks for all your responses, you have told me what I
need to know.
Peter
>--Original Message--
>Dear All,
>Our Server department would like to change the passwords
>of our Domain User accounts used by SQL Server and SQL
>Server Agent Accounts.
>Can anyone tell me the impact of this and whether we need
>to do anything at the SQL end.
>Regards
>Peter
>.
>