Getting rid of password

To remove a signing password, you can utilize the command line tools provided by Microsoft. For example, if you are using the SQL Server Migration Assistant (SSMA), you can execute the command to remove encrypted passwords. Here’s how you can do it:

1. Open the command prompt.
2. Navigate to the directory where the SSMA tool is installed.
3. Use the following command to remove the encrypted password:

      C:\SSMA\SSMAforAccessConsole.EXE -securepassword -remove all
   

   or for specific server IDs:

      C:\SSMA\SSMAforAccessConsole.EXE -securepassword -remove "source_1,target_1"
   

This command will remove the encrypted passwords from the protected storage file on your local machine. Make sure to replace source_1 and target_1 with your actual server IDs if you are removing specific ones.

References:

• Managing Passwords (AccessToSQL)
• Managing Passwords (OracleToSQL)
• Remove-EntraBetaPasswordSingleSignOnCredential
• Randomize passwords for cloud user accounts in Microsoft Entra ID
• Managing Password Synchronization

1. First, go to Settings > Accounts > Sign in options, scroll down to mid page, Make sure "For improved security, only allow Windows Hello Sign-in for Microsoft accounts on this device (Recommended). " is turned OFF.
2. Type netplwiz in the search on the taskbar and press enter, select your user, if the "user must enter a username and password to use this computer" box is NOT checked, please check it , click Apply. Then uncheck the box and click Apply. This will bring up a pop up window.
3. On this pop up window, this is where most mistakes happen. Very important, erase the username that's prefilled. Username should be your entire email address for your Microsoft account. Password is your Microsoft account's password. Any typo here can prevent it from working. Then click OK. And back to the netplwiz page, click OK.
4. Restart the computer now and it should work.