Re: Convert SQL logins to Windows authentication

From: Noone (IDontLikeSpam_at_nowhere.com)
Date: 08/06/05 

Date: Fri, 5 Aug 2005 22:27:26 -0700

Thanks Dan. Much appreciated :o)

"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:utDRMwhmFHA.516@TK2MSFTNGP10.phx.gbl...
> 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?
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Relevant Pages

  • Re: Convert SQL logins to Windows authentication
    ... SQL Server doesn't store passwords for Windows authenticated accounts since ... > SQL accounts...is there a known script/utility that can transfer the SQL> login passwords to the new corresponding Windows Authentication passwords? ...
    (microsoft.public.sqlserver.security)
  • Re: Locking down database accounts
    ... Windows Authentication rather than SQL Server user accounts and passwords. ...
    (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: User rights for creating Scheduled Jobs
    ... All of our users use Windows Authenticated accounts with rights ... connected with Windows Authentication, that Agent passes the empty string ... because the databases have been restored from another server. ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (comp.databases.ms-sqlserver)
  • Re: expire sql server 2000 passwords
    ... > Can and expiration date be assigned to sql server ... No, not natively by SQL Server, consider using Windows authentication where ... you can use password expiration. ...
    (microsoft.public.sqlserver.security)