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