Re: SQL 6.5 sa Password, how to change?
From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 02/05/04
- Previous message: Dan Guzman: "Re: sp_addalias bug?"
- In reply to: PBS: "Re: SQL 6.5 sa Password, how to change?"
- Next in thread: Steve Thompson: "Re: SQL 6.5 sa Password, how to change?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 4 Feb 2004 22:49:36 -0600
> After changing it I can no longer connect to SQL
> Server. Do I need to Stop/Start the service? I changed the PW both
through
> Enterprise Manager, and using sp_password. In both cases I had to change
it
> back using sp_password to the original PW in order to connect to SQL.
Are you having trouble connecting using 'sa' via Enterprise Manager? In
this case, you need to edit your Enterprise Manager server registration
properties to specify the new password. No need to restart SQL Server.
-- Hope this helps. Dan Guzman SQL Server MVP "PBS" <pbs@allwave.com> wrote in message news:uWSJ%23K46DHA.1556@tk2msftngp13.phx.gbl... > OK: > > I went ahead and changed the sa password. There must be some other gotcha > that I don't understand. After changing it I can no longer connect to SQL > Server. Do I need to Stop/Start the service? I changed the PW both through > Enterprise Manager, and using sp_password. In both cases I had to change it > back using sp_password to the original PW in order to connect to SQL. > > Any suggestions? > > Thank You, > Paul > >
- Previous message: Dan Guzman: "Re: sp_addalias bug?"
- In reply to: PBS: "Re: SQL 6.5 sa Password, how to change?"
- Next in thread: Steve Thompson: "Re: SQL 6.5 sa Password, how to change?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
