Monday, February 20, 2012

Moving logins to new server ??

Working on migrating a database used for a website
backend from an old server to a totally new one.
The new server already has some production databases
running on it.
The website database uses SQL authentication to grant
access to procedures/data on a per website user basis.
(i.e. user logs onto website over SSL with their SQL name
and password which is then used by ASP for any database
interaction)
There are HUNDREDS of logins.
Is there any way to move or copy these logins to the new
sever, complete with passwords?
If not, are there other options that don't involve
assigning everyone new passwords?
Thanks.Hi,
Have a look into the below link , This script will provide a easy method to
quickly generate a script that will move all logins along with same id and
password from one server to other.
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
MCDBA
"Nick J" <anonymous@.discussions.microsoft.com> wrote in message
news:138e201c44420$22b3afa0$a601280a@.phx
.gbl...
> Working on migrating a database used for a website
> backend from an old server to a totally new one.
> The new server already has some production databases
> running on it.
> The website database uses SQL authentication to grant
> access to procedures/data on a per website user basis.
> (i.e. user logs onto website over SSL with their SQL name
> and password which is then used by ASP for any database
> interaction)
> There are HUNDREDS of logins.
> Is there any way to move or copy these logins to the new
> sever, complete with passwords?
> If not, are there other options that don't involve
> assigning everyone new passwords?
> Thanks.|||PERFECT! THANKS !!!

No comments:

Post a Comment