Re: Script for sql logins
From: Jozsef (Jozsef.Gebri@caa.qld.gov.au)
Date: 04/01/03
- Next message: Edgardo Valdez: "Pesky Pop Ups"
- Previous message: Gary: "IIS"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Jozsef" <Jozsef.Gebri@caa.qld.gov.au> Date: Mon, 31 Mar 2003 15:58:22 -0800
Try the results from:
select 'exec sp_addlogin ['
+ name
+ '],'
, password
, ', @encryptopt=skip_encryption'
from master..sysxlogins
This will migrate your users and passwords between
servers, including from SQL 7 to 2000 (but not on SQL
6.5).
Jozsef ;-)
>-----Original Message-----
>If both servers are SQL 2000 then you can use a DTS
package. There is an
>object that you can add to the DTS package
called "Transfer Logins Task".
>
>--
>Denny Cherry
>Database Administrator
>GameSpy Industries
>
>"Manoj" <mgmanoj@hotmail.com> wrote in message
>news:03a601c2e8ab$f56fed40$3001280a@phx.gbl...
>> Hello
>>
>> when i generated the script using generate script
option
>> for sql server & windows login. All the users with sql
>> server login has now blank password.
>>
>> I wanted to move all users from one server to another.
>>
>> What is the option to keep the passwords same on both
the
>> servers.
>>
>> Thanks,
>>
>> Manoj
>
>
>.
>
- Next message: Edgardo Valdez: "Pesky Pop Ups"
- Previous message: Gary: "IIS"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
