Ver Mensaje Individual
  #3 (permalink)  
Antiguo 05/05/2006, 10:18
monkyta
 
Fecha de Ingreso: noviembre-2005
Mensajes: 658
Antigüedad: 19 años, 2 meses
Puntos: 3
Asi

I forgot/lost the sa password. What to do?

Forgot or lost your sa password? Don't worry, there is a way out :)

Login to the SQL Server computer as the Administrator of that computer. Open Query Analyzer and connect to SQL Server using Windows NT authentication. Run sp_password as show below to reset the sa password:

sp_password @new = 'will_never_forget_again', @loginame = 'sa'