Monday, March 19, 2012

migrate database incl. user and password to other server

hi all,
i need to migrate a database including the user and their passwords to
another server.
create the users manually is not possible because i do not know the
passwords. is there a possibility to get them to another db server?
i´m talking about sql server 2000 sp3
thanks
micHi
There are to stored procedures provided by MS to transfer logins with their
original SID
Search on internet for 'sp_help_revlogin'
"j.goines" <muchos@.hotmail.com> wrote in message
news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
> hi all,
> i need to migrate a database including the user and their passwords to
> another server.
> create the users manually is not possible because i do not know the
> passwords. is there a possibility to get them to another db server?
> i´m talking about sql server 2000 sp3
> thanks
> mic
>|||thanks a lot,
greets
mic
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:uZirDKNIGHA.984@.tk2msftngp13.phx.gbl...
> Hi
> There are to stored procedures provided by MS to transfer logins with
> their original SID
> Search on internet for 'sp_help_revlogin'
>
> "j.goines" <muchos@.hotmail.com> wrote in message
> news:e6z4rANIGHA.2948@.TK2MSFTNGP10.phx.gbl...
>> hi all,
>> i need to migrate a database including the user and their passwords to
>> another server.
>> create the users manually is not possible because i do not know the
>> passwords. is there a possibility to get them to another db server?
>> i´m talking about sql server 2000 sp3
>> thanks
>> mic
>

No comments:

Post a Comment