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: Brainwave: A Complete Web Platform With Database Out of the Box
    ... Its application server is built on CherryPy. ... And its database is its true gem. ... large form to fill out; huge license agreement; very little documentation outside of PDF; online demo links to a local IP address; NOTHING I can find on the website actually runs on Brainwave etc. etc. ... Spend all your time making your website look good with content that is available online easily. ...
    (comp.lang.python)
  • 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)