Re: Password for SQL Server
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 07/29/03
- Previous message: Sofya: "MS03-031 issue"
- In reply to: Marc Melfi: "Password for SQL Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 29 Jul 2003 18:45:53 +0100
Assuming you can access the server via NT authentication you can run
sp_password to change the sa password using NULL as the old password value .
See BOL for details of sp_password
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Marc Melfi" <melfibd@knology.net> wrote in message news:0a5801c355d3$54ea2f80$a401280a@phx.gbl... We have lost the sa password to the SQL server. Does any one have a way or idears on how to find or get by this. Thank you for any info. Marc
- Previous message: Sofya: "MS03-031 issue"
- In reply to: Marc Melfi: "Password for SQL Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
