开发者

ssms: adding a username

开发者 https://www.devze.com 2023-01-07 05:16 出处:网络
i would like to be able to access a database from a remote machine should i be adding a username in thi开发者_JS百科s prompt? if so, where do i input the password? i do not see the dialogue where i c

i would like to be able to access a database from a remote machine

should i be adding a username in thi开发者_JS百科s prompt? if so, where do i input the password? i do not see the dialogue where i can assign a password for a username? or maybe i can just use existing usernames? alt text http://img293.imageshack.us/img293/1919/15159985.png


Object Explorer > Security > Logins:

ssms: adding a username

That was present in 2005 as well.

Resources:

  • SQL Server 2005 Logins
  • Basic SQL Server Security concepts - logins, users, and principals


Right click on Logins under security from the management console. This will give you an option for a new login.

0

精彩评论

暂无评论...
验证码 换一张
取 消