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

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

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

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

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

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