验证SQL帐户密码是否有效

 在工作中，有些帐户的密码总是定期改变的，例如一些公用的测试帐号。

例如SQL Server上的一些帐户,前提是你已经安装了SQL Server,并且帐户是这个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:域名或者机器名/用户名 "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.