Re: Convert SQL logins to Windows authentication

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 08/06/05

  • Next message: Noone: "Re: Convert SQL logins to Windows authentication" 
    Date: Fri, 5 Aug 2005 19:16:08 -0500

    SQL Server doesn't store passwords for Windows authenticated accounts since
    Windows takes care of verifying the account. All you need to do is grant
    the existing Windows accounts access to SQL Server, grant database access
    and add the account to roles:

    EXEC sp_grantlogin 'MyDomain\SomeUser'
    GO
    USE MyDatabase
    GO
    EXEC sp_grantdbaccess 'MyDomain\SomeUser'
    EXEC sp_addrolemember 'MyRole', 'MyDomain\SomeUser'
    GO 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Noone" <IDontLikeSpam@nowhere.com> wrote in message 
news:%23xAR2CamFHA.3568@TK2MSFTNGP10.phx.gbl...
> Suppose I create the new Windows Authentication accounts for the existing 
> SQL accounts...is there a known script/utility that can transfer the SQL 
> login passwords to the new corresponding Windows Authentication passwords? 
> Just wondering since we have a bunch of users with SQL logins and that if 
> I created their Windows Authentication logins the passwords would have to 
> re-specified manually?
>
>
> "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message 
> news:eH%23J%23vSmFHA.3648@TK2MSFTNGP10.phx.gbl...
>> Hi,
>>
>> I dont think so. Because this sort of Login upgrades will come very 
>> rarely.
>>
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "John" <director0512athotmaildotcom> wrote in message 
>> news:OaJsHhRmFHA.1968@TK2MSFTNGP14.phx.gbl...
>>>I didn't think there was one either for SQL Server 2000.  Do you know if 
>>>there's going to be any new features/utilities that might be able to do 
>>>this in future SQL Servers?  Thanks a bunch Hari for your post.
>>>
>>>
>>> "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message 
>>> news:ucIE%23UPmFHA.572@TK2MSFTNGP15.phx.gbl...
>>>> Hi,
>>>>
>>>> ASAIK, there is no automated way to convert SQL logins to Windows 
>>>> users.
>>>>
>>>> You need to receate the Windows Logins manually in OS side (In the 
>>>> domain level) and then you
>>>> need to give access to that use in sql 2000 using sp_grantlogin 
>>>> [@loginame =] 'login'.
>>>>
>>>> After this you need to give exact precilages to this user in database 
>>>> level as well as server level.
>>>>
>>>> Thanks
>>>> Hari
>>>> SQL Server MVP
>>>>
>>>>
>>>> "Noone" <IDontLikeSpam@nowhere.com> wrote in message 
>>>> news:%23uC1fDLmFHA.576@TK2MSFTNGP15.phx.gbl...
>>>>>I was wondering if anyone knew if it's possible to easily convert 
>>>>>existing SQL Server logins and passwords to Windows Authentication 
>>>>>logins and passwords for a SQL Server 2000 database?  If so, does 
>>>>>anyone know of a script or utility that does this?
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
  • Next message: Noone: "Re: Convert SQL logins to Windows authentication"

    Relevant Pages

    • Re: Convert SQL logins to Windows authentication
      ... > SQL Server doesn't store passwords for Windows authenticated accounts ... > grant the existing Windows accounts access to SQL Server, ... >> login passwords to the new corresponding Windows Authentication ...
      (microsoft.public.sqlserver.security)
    • Re: Locking down database accounts
      ... Windows Authentication rather than SQL Server user accounts and passwords. ...
      (microsoft.public.sqlserver.security)
    • Re: Credentials not being passed with remote access
      ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
      (microsoft.public.sqlserver.security)
    • RE: Secure Logins for SQL Server 2000 on Novell Netowrk
      ... all the traffic to and from the client ... Is there a way I can use Windows authentication on the SQL server? ... you have to duplicate usernames and passwords on the machines. ...
      (microsoft.public.sqlserver.security)
    • Re: asp.net sql trusted connections between machines
      ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
      (microsoft.public.dotnet.framework.aspnet)