Re: login password changed
From: TomB (tbristow_at_brcllc.com)
Date: 10/14/04
- Next message: Sunny: "How to create table from existing table structure?"
- Previous message: nupee: "inserting into tables with many default constraints"
- In reply to: Bhanu: "Re: login password changed"
- Next in thread: Ann: "Re: login password changed"
- Reply: Ann: "Re: login password changed"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 14 Oct 2004 18:02:27 GMT
You may avoid this problem by using the master..sp_help_revlogin stored proc
available from Microsoft (reference Knowledge Base Article 246133). This
stored procedure will generate a script on the source server that can be
executed on the target server to create the logins with their original SIDs
and passwords.
"Bhanu" <SQLDBA1999@yahoo.com> wrote in message
news:ufoToIhsEHA.3320@TK2MSFTNGP15.phx.gbl...
> I think this is done for security reasons. The passwords after transfer
> gets encrypted that way SA or equivalent user will reset the passwords.
> Thereby implicit privileges will not be available to the login without the
> administrator's knowledge.
>
> Bhanu.
>
>
> "Ann" <Ann@discussions.microsoft.com> wrote in message
> news:4446F314-A347-4EBC-B621-798CFE959B12@microsoft.com...
> > We have a testing server. Sometimes we need to move some logins and
users
> > from production server to the testing server, I use transfer login or
copy
> > objects dts,
> > Then some of our web pages cannot be acceessed by the logins.
> >
> > And I checked there was no orphaned users.
> >
> > Finally found the password is changed while transfer, change it to
> oringinal
> > password, then it works.
> >
> > My question is why the password changed during transfer or moving logins
> or
> > users?
> > We didn't change it manually at all.
> >
> > Is this a bug ? or is this a problem many users have?
> >
> > Thanks
>
>
- Next message: Sunny: "How to create table from existing table structure?"
- Previous message: nupee: "inserting into tables with many default constraints"
- In reply to: Bhanu: "Re: login password changed"
- Next in thread: Ann: "Re: login password changed"
- Reply: Ann: "Re: login password changed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
