Re: How to cpy logins from one Server to another

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/29/03 

Date: Mon, 29 Dec 2003 12:25:19 -0500

Here are some links related to that subject:

http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf 

-- 
Andrew J. Kelly
SQL Server MVP
"Félix Meléndez" <fmelende@ibw.com.ni> wrote in message
news:%2383aC1izDHA.604@tk2msftngp13.phx.gbl...
> Hi there! I don't remember if it was about 1 or 2 months ago that I posted
> this same question.  I wanted to know how to copy logins from one server
to
> another.  Some one pointed to me an url to at microsoft knowledgebase, but
I
> lost it.  Can some one or the person who helped me that time send me one
> more time the url.
>
> Thanks in advance,
>
> --
> Félix Meléndez
> PCI
> Managua, Nicaragua
>
>

Relevant Pages

  • Re: How to upgrade MSDE databases to SQL Server Databases
    ... First however we are going to permute the install sequence on a 'web ... farm' parameter and then permute a server target on the WSS Web Admin ... between Microsoft Access, MSDE, SQL Server Express and SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Backup issues after changing administrator name
    ... I set the relevant sql server databases to simple and ... You back up data from a volume that contains a Microsoft SQL Server ... > As creating the volume shadow copy failed, the open files shown in the log ... > CSS (Customer Support Service) for the following hot fix. ...
    (microsoft.public.windows.server.sbs)
  • Re: Moving SQL to a new server.
    ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... How To Transfer Logins and Passwords Between SQL Servers ... Disaster Recovery Articles for SQL Server ... > I was reading another thread about copying SQL server databases and logins> to a new server. ...
    (microsoft.public.sqlserver.programming)
  • Re: Restoring sql server database from one server to another from a ba
    ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... Errors After Restoring Dump ... for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Please answer my queries for fresh Installation
    ... SQL Server, It will create Master, MSDB databases. ... >Moving SQL Server Databases ... >How To Transfer Logins and Passwords Between SQL Servers ...
    (microsoft.public.sqlserver.server)