Login into SQL Server using Windows Authentication.
In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.
The Simple trick is to check the box “Map to credential” as shown below after providing a new password and click Okay.
In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.
The Simple trick is to check the box “Map to credential” as shown below after providing a new password and click Okay.
