Re: Creating Windows Authenticated User

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 11/21/03

  • Next message: Ray Higdon: "Re: xp_sendmail error: Cannot generate SSPI context" 
    Date: Fri, 21 Nov 2003 11:25:02 +0100

    Use sp_grantlogin for Win users - you grant them access, you don't create
    them:
    EXEC sp_grantlogin 'Corporate\BobJ' 

    -- 
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Mark Vergara" <markvergara007@hotmail.com> wrote in message
news:OOOF27#rDHA.2456@TK2MSFTNGP12.phx.gbl...
> Hi,
>
>         I want to know  how to create a Windows Authenticated user
> because I always use this command to create  a Microsoft SQL Server
> Login
>
> sp_addlogin [ @loginame = ] 'login'
>     [ , [ @passwd = ] 'password' ]
>     [ , [ @defdb = ] 'database' ]
>     [ , [ @deflanguage = ] 'language' ]
>     [ , [ @sid = ] sid ]
>     [ , [ @encryptopt = ] 'encryption_option' ]
>
>  Is there a code or script that use to create a Windows User ?
>
> Thanks
> Mark Vergara
> Programmer
>
>
>
  • Next message: Ray Higdon: "Re: xp_sendmail error: Cannot generate SSPI context"

    Relevant Pages

    • Re: Multi Dimensional Cases in Time Series
      ... This message does not imply endorsement from Solid Quality Learning, ... >> - in SQL Server, create a linked server to the Analysis Services ... >> Dejan Sarka, SQL Server MVP ...
      (microsoft.public.sqlserver.datamining)
    • Re: security based on value of X inside a table!
      ... Dejan Sarka, SQL Server MVP ... "Lars Grøtteland" wrote in message ... >> Dejan Sarka, SQL Server MVP ...
      (microsoft.public.sqlserver.security)
    • Re: Comparision on Char Column With Alphanumeric Values
      ... >> Dejan Sarka, SQL Server MVP ... >>> The query returns 0 records, whereas ideally it should return records ...
      (microsoft.public.sqlserver.server)
    • Re: Services account
      ... Dejan Sarka, SQL Server MVP ... >> Dejan Sarka, SQL Server MVP ... >> Solid Quality Learning ...
      (microsoft.public.sqlserver.setup)
    • Re: storing passwords inside a table?
      ... Dejan Sarka, SQL Server MVP ... >> Dejan Sarka, SQL Server MVP ... >> Please reply only to the newsgroups. ...
      (microsoft.public.sqlserver.security)
    • Quantcast