How to login to SQL Server with different OS account?
Solution:
runas /user:domain\new_user "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
e.g.
runas /user:MySrvl\testuser "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
PS.
If specifying /netonly argument, SSMS will run the desired OS credential only for remote host (including local host).
文章標籤
全站熱搜
