> Maybe there is no way to create a sql server login in SSMS?

It seems you are viewing the database security node (Database-->Security)
rather than the server security node (Server-->Security). The server
Security node contains the server-level security objects Logins, Server
Roles and Credentials. You can also use the Server security node to map
logins to users and assign database role memberships.

--
Hope this s.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Tina" <TinaMSeaburn@nospamexcite.com> wrote in message
news:uoh5bOTkIHA.5160@TK2MSFTNGP05.phx.gbl...
> This has been a point of confusion because I have heard this before but
> there is no "login" node under security in the object explorer of SSMS.
> There is just Users, Roles, Schemas, Asymmetric Keys, Certificates, and
> Symmetric Keys. No Logins.
>
> Maybe there is no way to create a sql server login in SSMS?
> T
>
>
> "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
> news:A1E516AB-A168-4ECD-8F9A-95CE7E4075D7@microsoft.com...
>>> I want to know how to ADD A USER for a database using only sql server
>>> authentication. The add user dialog always insist that the user be a
>>> local login.
>>
>> You need to add the SQL login before you add the database user. You can
>> create both the server login and database user from the SSMS Object
>> explorer by right-clicking on the Logins node under Security and then
>> select New Login. The dialog allows you to create the new login as well
>> as create the database user (user mapping).
>>
>> Alternatively, you can do this via script. For example:
>>
>> USE MyDatabase
>> GO
>> CREATE LOGIN SomeLogin WITH PASSWORD = 'S0Mel0g1n';
>> CREATE USER SomeLogin;
>>
>> --
>> Hope this s.
>>
>> Dan Guzman
>> SQL Server MVP
>> http://weblogs.sqlteam.com/dang/
>>
>> "Tina" <TinaMSeaburn@nospamexcite.com> wrote in message
>> news:u5TwNJFkIHA.4940@TK2MSFTNGP02.phx.gbl...
>>> My instance of SQL Server is, of course, setup for both Windows and sql
>>> server authentication. This is not my question. I want to know how to
>>> ADD A USER for a database using only sql server authentication. The add
>>> user dialog always insist that the user be a local login.
>>> T
>>>
>>> "Hurme" <michael.geles@thomson.com> wrote in message
>>> news:6497FB2A-B897-4576-9263-3C714E2D7D28@microsoft.com...
>>>> You need to configure the server to use SQL Authentication.
>>>>
>>>> Im EM (2000) or SSMS(2005) right click on the server and choose
>>>> properties.
>>>> Click on Security and then SQL Server and Windows and then Ok.
>>>>
>>>> --
>>>> MG
>>>>
>>>>
>>>> "Tina" wrote:
>>>>
>>>>> I want to create a user that will use SQL Server Authentication to
>>>>> access my
>>>>> database. I am using Management Studio. If I try to add a user MS
>>>>> insists
>>>>> that it be a local logon. How do we create users that are not going
>>>>> to be
>>>>> authenticated by Windows?
>>>>> Thanks,
>>>>> T
>>>>>
>>>>>
>>>>>
>>>
>>
>