18th March 18:07
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
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
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.