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).

 

 

arrow
arrow
    全站熱搜

    DanBrother 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄