Moving logins to new server ???

From: Nick J (anonymous_at_discussions.microsoft.com)
Date: 05/27/04 

Date: Thu, 27 May 2004 12:23:48 -0700

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: database server audit tools
    ... * Oracle Application Server ... please send me also some links to harden my database server from attacks.. ... Audit your website security with Acunetix Web Vulnerability Scanner: ...
    (Pen-Test)
  • Re: Databse Results
    ... Therefore as the webmaster I can grant access to the other website via the control panel. ... database in another website, unless the sites are under a single user account and on the same server.". ... > Thomas A. Rowe (Microsoft MVP - FrontPage) ...
    (microsoft.public.frontpage.client)
  • Re: Publishing data from WinForms application to the web
    ... But this client app should have access to WebSite DB. ... I am using SQL Server 2005. ... I am creating a WinForms application for a client. ... Server database up to a database on a website also SQL Server 2005). ...
    (microsoft.public.vsnet.general)
  • Re: Databse Results
    ... If any host allows one website to see or access another website's database ... Thomas A. Rowe (Microsoft MVP - FrontPage) ... > A web server can also be a file server, ...
    (microsoft.public.frontpage.client)
  • Re: securing a database deployment
    ... > will have admin access on the server through Terminal services ... > backup copy of my db and install it using Restor Database command in the ... > available also on the web.config file of the ASP.net website .. ...
    (microsoft.public.sqlserver.security)