Re: Yukon and mixed mode for msde database?

From: Michael Tissington (michael_at_nospam.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 14:45:27 -0700

Its also required when your computers are not part of a domain, else it
becomes very complicated to manage multiple logons on the different
machines. 

-- 
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com
"dev" <anonymous@discussions.microsoft.com> wrote in message
news:67422C37-0C81-46CA-9A3D-4F84BDDA296F@microsoft.com...
> Thanks Aaron for your reply.
>
> Here is one article I remember reading very recently .. by a leading
author Mike Gunderloy which states something like:
>
> "We recommend using Windows Authentication mode when possible. However,
Mixed mode is required when working with SQL Server 7.0 (or earlier). SQL
Server Authentication (Mixed) is provided for backward compatibility with
earlier versions of SQL Server. "
>
> read it here
> http://builder.com.com/5102-6388-5035150.html
>

Relevant Pages

  • Re: Regarding setup for SharePoint Services 2.0...
    ... But after installation, all WSS functionality will ... continue to work if you switch back to Mixed Mode. ... like) that get real flaky if you are not running in Windows Only SQL Server ... advantages to Microsoft from a security perspective moving to a Windows Only ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Regarding setup for SharePoint Services 2.0...
    ... that means it's OK to set up SQL Server ... authentication as mixed mode when installing WSS? ... > following the single-server installation guide for that product. ... > mode or when wondering if mixed mode is a solid solution. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Regarding setup for SharePoint Services 2.0...
    ... For what it's worth I've just done a Project Server 2003 installation ... to the SQL Server 2K installation part of the guide it stressed that SQL ... Server 2K must be installed in mixed mode because you were going ... > advantages to Microsoft from a security perspective moving to a Windows ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Backup Users
    ... Moving DB's between ... Moving SQL Server ... > a Restore ... > "Michael Tissington" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Questions about SQL on SBS Premium
    ... Changing the authentication from Windows to Mixed mode will not ... Just make sure you secure this SQL Server ... The authentication mode needs to be set to mixed mode (it is currently ...
    (microsoft.public.windows.server.sbs)