ssms: adding a username
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:
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.
精彩评论