Sometime we forgot sa password of MSSQL.
sometime we ignore password while installation.
We can change ‘sa’ password, but we need to open ‘Enterprise manager or SQL management studio’ and authenticate with Windows authentication.
One should login on windows in that user, which was used to install MsSql
or definitely ‘Administrator’ user can do anything
if you are authenticate in MSSQL, open new query, ( master database must be used, or we are running query on master database)
alter login sa with password='abc123#'
execute above code,
now you can login with sa user with password:abc123#