Verify that the SQL account password is valid

At work, the passwords of some accounts are changed regularly, for example, some public test accounts.

For example, if you have already installed SQL Server and the account is a valid user of SQL Server

 

1. Run cmd

2. Type COMMAND: RunAs /?

3. Click Enter key

4. Go bottom and see the exampless

5. clict the start button

6. Find the SQL Server Management Studio

7. Select it and right clickt

(Refer to the PIC in Attachment)

8. Copey target

9. Go back the command

10. Type COMMAND: RunAs/noprofile/User: domain name or machine name/User Name "C:/program files/Micros
Oft SQL Server/100/tools/binn/vsshell/common7/IDE/ssms.exe"

11. Click Enter key

12. input the PWD

 

Result: If the PWD is right, the SQL server program will luanch.