Security Migration

From: Mike Dale (MikeDale_at_discussions.microsoft.com)
Date: 06/22/04 

Date: Mon, 21 Jun 2004 16:26:01 -0700

Hey All, I realize this has probably been asked before, however I am a fairly new DBA of SQL Server.

I have just finished setting up SQL Server on our new hardware, and I have used the previous day's comressed backup files to quickly copy the databases from one server to another. I then restored the databases on the new server. The only trouble is, each of the databases have Users that do not exists as Logins on the new server.

Is there an easy way to load all of the security login information from my old server to the new server, such that it uses the same IDs in the background, so that I don't have to rebuild the security settings?

FYI: I am moving from SQL Server 2000 SP3 on Server 2000 to SQL Server 2000 EE SP3+Hotfixes on Advanced Server 2003, if that makes any difference.

Thanks,

Relevant Pages

  • Re: Using sql server clustering
    ... Clustering will give that one high availability. ... other 4 can still handle the load while you fix the one that is down. ... add more server for incoming data wich is failover cluster. ... About the servers to pull data, can i use sql server clustering in order ...
    (microsoft.public.sqlserver.clustering)
  • Re: Database partitioning - licensing issues
    ... We're a small company and have SQL Server 2005 EE regularly crunch 100 ... We plan to spread this load on multiple servers, ... on other servers to get the table partitioning to ...
    (microsoft.public.sqlserver.setup)
  • Re: Using sql server clustering
    ... You need to use some sort of load balancing for the web servers that spreads ... wouldn't bother with clustering them. ... I would add a 5th read server so ... About the servers to pull data, can i use sql server clustering in order ...
    (microsoft.public.sqlserver.clustering)
  • Re: load balancing question
    ... As Eric states you can not use NLB to load share with SQL Server unless the ...
    (microsoft.public.sqlserver.server)
  • Diagnose Application bottleneck
    ... I am looking at an application which runs from Windows 2000 server, ... The site is load balanced between two servers using Windows Loadbalancing. ... It uses ASP for the front end and SQL server 2000 running ... The SQL server tends to use less than 30% CPU with occassional spikes to 60% ...
    (microsoft.public.inetserver.asp.db)