PHWinfo - Afficher un message

29/03/2008, 01h26

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

29/03/2008, 01h26	#5
Tina Messages: n/a Hébergeur:	Re: SS authentication question 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 >>>> >>>> >>>> >> >