Re: Moving logins to new server ???

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/28/04 

Date: Fri, 28 May 2004 12:30:19 +0530

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/features/mssql/article.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.

Relevant Pages

  • Re: Directing web forms to numerous databases
    ... First you have to get the form POST data to a programmable computer. ... If you can script the website itself, ... Presumably the database is on ...
    (microsoft.public.access.modulesdaovba)
  • Re: Domain change for logins & users
    ... Please do not directly update sysxlogins. ... sp_helplogins -- returns all the logins and database roles to which they ... Script those as well. ... Run appropriate scripts in each database to assign the new logins to the ...
    (microsoft.public.sqlserver.security)
  • Tree menu
    ... I have a website that does not have a database associated with it. ... original version of the web site had a menu on the left side of the screen ... generate the menu from a script. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Copying users to new server
    ... I think although he/she has the same logins moving users to the new server ... > Generate SQL Script; ... > Script database users and database roles and ...
    (microsoft.public.sqlserver.security)
  • RE: default database for scripts in SSMS
    ... Change the user default database. ... Go to Security, Logins, right-clik your ... script runs against, ... rarely run scripts against the master database, so is there an option to have ...
    (microsoft.public.sqlserver.tools)