Re: Migrating from NT to Win2k in native mode

From: Narayana Vyas Kondreddi (answer_me@hotmail.com)
Date: 07/26/02 

From: "Narayana Vyas Kondreddi" <answer_me@hotmail.com>
Date: Fri, 26 Jul 2002 11:48:51 +0100

Upgrade should be straight forward, no issues. Did you say you are switching
from mixed mode authentication to Windows only authentication? Then you
better test all your applications, jobs, DTS packages etc. The following
link might help:

What are the effects of switching SQL Server from 'Mixed mode' to 'Windows
only' authentication mode? What are the steps required, to not break
existing applications?
http://vyaskn.tripod.com/administration_faq.htm#q19 

--
HTH,
Vyas, MVP (SQL Server)
Check out my SQL Server website @
http://vyaskn.tripod.com/
"Rino D'Errico" <rino.derrico@videotron.ca> wrote in message
news:12e401c23419$5518a360$37ef2ecf@TKMSFTNGXA13...
> Are there any know issues with migrating from SQL 7.0 /
> NT 4.0 domain to a SQL 7.0 / Windows 2000 domain in
> NATIVE MODE?  We currently use mixed authentication on
> the SQL box.
>
> Thanks,
> Rino.

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for ServerGuest
    ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
    (microsoft.public.sqlserver.connect)