Re: Logins between SQL Databases on diff. servers.

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

Date: Tue, 9 Sep 2003 07:51:04 -0400

If they are NT logins and on the same domain you shouldn't have to do
anything after you create them as the SID is always the same. These should
help:

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
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server 

-- 
Andrew J. Kelly
SQL Server MVP
"Ata John" <atajohn@john1.tg> wrote in message
news:3F5D35DC.5060609@john1.tg...
> Hi All,
>
> I just created one server with SQL 7.0 to offload our servers before the
> 2000 migration. I would like to migrate the logins first to that new
> server before the data. I have tried to use Import/Export with the 3
> option to move objects etc but it failed. I am guessing that because the
> logins are missing, it cannot restore objects to owners.
> So how can I move the logins first with its passwords and SID?
> Or should I restore from backups and then fixed the logins?
>
> Thanks for your help.
>
> Ata John
>

Relevant Pages

  • Re: NT > 2003 domain name changes
    ... Can't use the DTS option as it doesn't retain the SID, ... -restore database to SQL2K ... - cut out logins that do not apply to the database at hand ... >> windows authentication over to a new sql server on a new ...
    (microsoft.public.sqlserver.security)
  • Re: User already exists in the database error
    ... I suggest you create the logins *with the correct SID* before restoring. ... I need to have the users already created on the SQL server yes? ...
    (microsoft.public.sqlserver.server)
  • Re: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • Re: Restore master?
    ... The Logins would come with Master but the users are stored in each db. ... Errors After Restoring Dump ... for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)