ssms: adding a username

Question

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

should i be adding a username in this 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?

Answer 1

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

Answer 2

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