Re: Convert SQL logins to Windows authentication

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

Date: Fri, 5 Aug 2005 02:32:50 -0700

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: Locking down database accounts
    ... our company's policy is to use SQL security instead ... of Windows authentication. ... passwords, but then decryption information and setup would ...
    (microsoft.public.sqlserver.security)
  • Re: How to restrict access our DB on SQL server.
    ... Don't give out the passwords and they won't be able to login. ... Andrew J. Kelly SQL MVP ... Excel & even Enterprise manager? ...
    (microsoft.public.sqlserver.tools)
  • Re: How to implement Windows Authentication?
    ... the login should be created outside the ... Candidate 2 may have no or limited SQL knowledge. ... the Windows groups/users who will run the application. ... using Windows Authentication or SQL Authenticaton. ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie: guest account with SSPI
    ... you need to add a SQL login for MYDOMAIN/johnd ... However, may I suggest you create a Local Group on the SQL Box, add domain ... > 1) Is this a Windows Authentication problem or an SQL server problem? ...
    (microsoft.public.sqlserver.server)
  • Re: How to implement Windows Authentication?
    ... but why would you want that app creates a login? ... using Windows Authentication or SQL Authenticaton. ... If the application is configured to use SQL Authentication (SQL Server is ...
    (microsoft.public.sqlserver.security)