Thanks guys - all sorted was having a brainwave - logged in with Windows
Authentication and changed sa's properties in Logons

Thanks for your help.
Steve

-----Original Message-----
From: daniel
[mailto:mssqldba-ezmlmshield-x472308.[Email address protected]
Sent: 27 April 2007 12:31
To: LazyDBA Discussion
Subject: Re: Changing sa account details

Hi Steve

EXEC sp_password NULL, 'password', 'sa';

... you need to be sysadmin to do this

But before doing this I would run the Profiler to monitor any logins
with
sa
It could be that some applications use this account to update data
(don't
laugh - I've seen this!)
... they will break if you change the password ...

Good luck
Daniel




"Steve Faulkner " <mssqldba-ezmlmshield-x62584036.[Email address
protected]

27.04.2007 12:24

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Changing sa account details






Hi Guys,



Probably a really stupid question and I'll most likely kick myself when
I find out the answer or not as case may be.



I have full administrative rights to a sql instance I have inherited -
however the sa password is not known by anybosy - is there a way to
either change it or find out what it is from the system?



Thanks

Steve


________________________________________________________________________
FFastFill plc is a public limited company registered in England and
Wales
with details as follows;
Registered Office: 1-3 Norton Folgate, London E1 6DB Company
Number:978346

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[Email address protected]

This email has been scanned for all viruses by the FFastFill Email
Security System.
________________________________________________________________________


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
This e-mail may contain confidential material. It is intended only for
the person or entity which it is addressed to. Any review,
retransmission, dissemination or other use of this information by
persons or entities other than the intended recipient is prohibited. If
you received this e-mail in error, please immediately notify the sender
or The Swiss Raiffeisen Group and delete the material from any and all
computers it may be stored on. Any views or opinions expressed in this
e-mail are those of the sender and do not necessarily coincide with
those of The Swiss Raiffeisen Group. Therefore this e-mail does not
represent a binding agreement nor an offer to deal. E-mail transmission
cannot be guaranteed to be secure or error-free. Information could be
intercepted, corrupted, lost, destroyed, incomplete or may contain
viruses. Neither The Swiss Raiffeisen Group nor the sender can accept
any liability for any kind of damage as the result of viruses or
transmission errors.
**********************************************************************



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


________________________________________________________________________
FFastFill plc is a public limited company registered in England and Wales with details as follows;
Registered Office: 1-3 Norton Folgate, London E1 6DB Company Number:978346

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[Email address protected]

This email has been scanned for all viruses by the FFastFill Email
Security System.
________________________________________________________________________

MS Sql Server LazyDBA home page