Get sa password

Hey,
I admin an company with MS SQL-Server. They forget the sa-password. Is there
any way to get the password from an running sql-server? I need it for
SQL-Backup!
Thanks for answere
FrankAre you using mixed mode that has an NT account with sysadmin rights? if so,
log that account then change the sa password.
What version are you running?
Thomas
"Frank Moskopp" wrote:

> Hey,
> I admin an company with MS SQL-Server. They forget the sa-password. Is the
re
> any way to get the password from an running sql-server? I need it for
> SQL-Backup!
> Thanks for answere
> Frank
>
>|||I have no access with my NT accounts. The company run SQL-Server 2000.
Thanks for more information
Frank
"Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...[vbcol=seagreen]
> Are you using mixed mode that has an NT account with sysadmin rights? if
> so,
> log that account then change the sa password.
> What version are you running?
>
> --
> Thomas
>
> "Frank Moskopp" wrote:
>|||What service account is SQL running under ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
news:djrccf$qtb$1@.newsreader3.netcologne.de...
>I have no access with my NT accounts. The company run SQL-Server 2000.
> Thanks for more information
> Frank
>
> "Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
>|||If you have NT authentication enabled you should be able to logon as a local
administrator and then change the sa password (this assumes that builtin
admins has not been removed from SQL)
http://vyaskn.tripod.com/administration_faq.htm#q9
Thomas
"Frank Moskopp" wrote:

> I have no access with my NT accounts. The company run SQL-Server 2000.
> Thanks for more information
> Frank
>
> "Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6A73707E-E854-4FAA-BF35-3DE2178766A1@.microsoft.com...
>
>|||Hi,
Talk to you system admin about this. Using his windows admin login login to
server and connect to SQL Server using Windows authentication.
After that change your SA password using (SP_Password null,newpassword,sa).
After this you could login using new password and do necessary Admin tasks.
Thanks
Hari
SQL Server MVP
"Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
news:djr6ja$f3q$1@.newsreader3.netcologne.de...
> Hey,
> I admin an company with MS SQL-Server. They forget the sa-password. Is
> there any way to get the password from an running sql-server? I need it
> for SQL-Backup!
> Thanks for answere
> Frank
>|||I have 3 mssql-services. It's run on an SBS 2003 Standard-Server. The
application 'Act!' install the SQL-Server. I coundn't set an sa password.
The application manage the service of MSSQL$ACT7. The service of
'Sharepoint' run with the NT admin account.
I need the sa password for my Veritas SQL-Backup and maybe for maintenance.
Services:
MSSQL$ACT7
MSSQL$Sharepoint
MSSQL$xxxx
Frank
"Jasper Smith" <jasper_smith9@.hotmail.com> schrieb im Newsbeitrag
news:u31L0az2FHA.1980@.TK2MSFTNGP15.phx.gbl...
> What service account is SQL running under ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
> news:djrccf$qtb$1@.newsreader3.netcologne.de...
>|||Hey Thomas,
The progamm 'act' manage the MSSQL-service. I need the actually password and
not any new password.
Frank
"Thomas" <Thomas@.discussions.microsoft.com> schrieb im Newsbeitrag
news:A17984F0-5540-4BC1-9A2E-C69AB3647256@.microsoft.com...[vbcol=seagreen]
> If you have NT authentication enabled you should be able to logon as a
> local
> administrator and then change the sa password (this assumes that builtin
> admins has not been removed from SQL)
> http://vyaskn.tripod.com/administration_faq.htm#q9
>
> --
> Thomas
>
> "Frank Moskopp" wrote:
>|||Hey Hari,
The progamm 'act' manage the MSSQL-service. I need the actually password and
not any new password.
Thanks
Frank
"Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
news:e%23o60642FHA.3276@.TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Talk to you system admin about this. Using his windows admin login login
> to server and connect to SQL Server using Windows authentication.
> After that change your SA password using (SP_Password
> null,newpassword,sa).
> After this you could login using new password and do necessary Admin
> tasks.
> Thanks
> Hari
> SQL Server MVP
>
> "Frank Moskopp" <FMoskopp@.Moskopp.org> wrote in message
> news:djr6ja$f3q$1@.newsreader3.netcologne.de...
>|||Frank Moskopp wrote:
> Hey Hari,
> The progamm 'act' manage the MSSQL-service. I need the actually password a
nd
> not any new password.
> Thanks
> Frank
> "Hari Prasad" <hari_prasad_k@.hotmail.com> schrieb im Newsbeitrag
> news:e%23o60642FHA.3276@.TK2MSFTNGP10.phx.gbl...
>
You can't get the actual password for sa- you'll have to enter a new
one. You might be able to contact the application vendor and ask them
for the sa password since it sounds like the program is assigning a sa
password during installation. Maybe it's a standard password (God forbid
it...) and then they can tell you what it is.
Regards
Steen