RE: SQL server migration

Hi,

First, which authentication method did you use? Windows Authentication or
Mixed authentication? Basically if you enabled SID history feature in AD,
the users are still able to log in with old sid. If you want to remove sid
hirstory, check following steps:

1) Stopped all SQL Related Services and modified the startup mode to
manual.
2) Migrated SQL Server to new domain.
3) Modified the startup account for SQL.
4) Started SQL Server.
5) Generate output of sp_help_revlogin stored procedure.
6) Generated Permission script.
7) Detached all the user Database.
8) Dropped all the logins.
9) Used the permission script to recreate logins and add server level roles
10) Attached the user database.
11) Mapped the SIDS using sp_sidmap procedure.

SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://support.microsoft.com/?id=298897

Hope this helps.


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
Thread-Topic: SQL server migration
thread-index: AcaVGBDFQvJSFQMgThGz32GTWtzwPg==
X-WBNR-Posting-Host: 70.48.246.247
From: =?Utf-8?B?SnVsaWFuYQ==?= <Juliana@xxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: SQL server migration
Date: Wed, 21 Jun 2006 02:50:01 -0700
Lines: 5
Message-ID: <FDD878C4-8405-4E9E-85AE-EB723682652C@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.windows.server.migration
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.windows.server.migration:24161
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.windows.server.migration

I am sorry, forgot to mention in last post that the member server run SQL
server and application which in a NT domain, how to migrate it to windows
2k3
domain without affect users to access.

Thank you,


.

Relevant Pages

  • RE: NT4 Migration
    ... My understanding is you want to restructure the NT4 domain into a AD ... I know your major concern is move SQL server 2000 to new domain. ... Basically if you enabled SID history feature in AD, ... Detached all the user Database. ...
    (microsoft.public.windows.server.migration)
  • RE: SQL server migration
    ... which authentication method did you use? ... Basically if you enabled SID history feature in AD, ... Migrated SQL Server to new domain. ... Detached all the user Database. ...
    (microsoft.public.windows.server.migration)
  • Re: Authentication and security in .NET Remoting
    ... The article does authentication based on Windows authority... ... Is it possible to authenticate against my own user database? ... a table inside SQL Server? ... Prev by Date: ...
    (microsoft.public.dotnet.framework.remoting)
  • 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: outlook prompts for credentials
    ... Domain B account which doesn't have the same SID as the user in Domain ... probably chose domain-wide authentication or forest-wide authentication ... server without being asked for credentials... ...
    (microsoft.public.exchange.clients)