Thursday, July 4, 2019

SQL Server password reset

on the cmd prompt:
-----------
osql -L
--will list all the db servers in the network
osql -S machinename(or)localhost -E
--will get a prompt.

>sp_password NULL,123,'sa'
>GO

now the credentials:
username: sa
password: 123


Reference:







No comments:

Post a Comment