Password for SQL Server
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
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
|