RE: ADMTv3 and SQL Windows authentication permissions

Hi,

Regarding sql 2000 migration between domains, you should consider two phase:

Phase 1: Migrate the sql 2000 server as normal memeber server migration.

Phase 2: Use Mapsids.exe to map SIDs between user and master Databases.
Check followin article:

SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When
Database Is Moved
http://support.microsoft.com/default.aspx?scid=kb;%5bLN%5d;298897


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: ADMTv3 and SQL Windows authentication permissions
thread-index: Aca7+4vniGoBnMkaTFChhSmEQMg3aA==
X-WBNR-Posting-Host: 68.77.208.5
From: =?Utf-8?B?am1wMTM=?= <jmp13@xxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: ADMTv3 and SQL Windows authentication permissions
Date: Wed, 9 Aug 2006 14:34:08 -0700
Lines: 4
Message-ID: <153884C4-9E8F-4463-A45A-88AA774F617A@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:24750
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.windows.server.migration

I'm planning on moving a SQL Server 2000 2-node cluster in a Windows 2000
domain that uses Windows authentication to a Windows 2003 domain. Can the
ADMTv3 modify the SQL permissions or is there another tool available that
can
handle that function?


.

Relevant Pages

  • Re: Q: Named pipes and Windows (integrated) authentication
    ... >By the way, if you don't have SQL Enterprise Manager, there's an MSDE ... >>>his windows authentication to connect to the server. ... >>>Creating databases is only acomplished after you've already connected. ...
    (microsoft.public.sqlserver.connect)
  • RE: MELL and SQL
    ... At this point I'm logged in as admin and since ... have the necessary permissions for the installation. ... > Most third party apps don't use Windows Authentication, they use SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server Authentication
    ... I'm sorry to hear you are having some troubles with SQL authentication. ... can I would love to persuade you to use Windows authentication if at all ... > With VSTO using Visual Studio 2005, has anyone manage to use SQL Server ...
    (microsoft.public.vsnet.vstools.office)
  • Re: SQL Server uses Windows authentication
    ... > With Windows Authentication you do not put any credentials in the ... The connection uses the credentials of whatever ... >> 1 remote web server to connect to an SQL db on a completely different ...
    (microsoft.public.inetserver.asp.db)
  • Re: Login failed for ServerGuest
    ... SQL Server clients are authenticated as guests if Simple ... >| I have noticed that when I try to log in using Windows Authentication ... >|> You can enable the guest account but that's a security risk ...
    (microsoft.public.sqlserver.connect)