Re: Regarding setup for SharePoint Services 2.0...

From: (todd_at_N*O*S*P*A*M*mindsharp.com)
Date: 01/23/05 

Date: Sun, 23 Jan 2005 00:26:37 -0600

In my experience, you may have installation problems if you are running SQL
Server in Mixed Mode. But after installation, all WSS functionality will
continue to work if you switch back to Mixed Mode. However, as I understand
it, there are some SPS features (Shared Services, Single Sign On, and the
like) that get real flaky if you are not running in Windows Only SQL Server
mode. I have successfully had WSS running in SQL Server Mixed Mode for
circumstances similar to what you've described.

That said, you really want to begin moving your legacy applications to the
Windows Only SQL Server mode. I would doubt very much if Microsoft will
continue support for Mixed Mode in the future. This may have even been
deprecated in SQL Server 2005 (does anyone know?). Think about the
advantages to Microsoft from a security perspective moving to a Windows Only
model:
  Complex password policies enforced
  Change passwords frequency policies enforced
  Domain trusts enabled
  Greater access control available
  Roles-based authorizations are easier to maintain
  Increased flexibility and security for remote employees
  PKI-enabled smart card and biometric authentication possibilities
  Security groups and GPO capabilities available
  ACLs can be set on carefully defined sets of resources
  Single security context for the end user

I'm sure the list goes on. It's only my speculation and I may not have even
hit on the most important reasons but I believe that Mixed Mode SQL Server
authentication will likely go away completely in the future. But that's just
one guys opinion.

HTH,

<Todd />

"Juan T. Llibre" <nomailreplies@nowhere.com> wrote in message
news:emKhgcIAFHA.1300@TK2MSFTNGP14.phx.gbl...
> This is probably a dumb question, but...
>
> There's a heading in the "Single Server Deployment"
> section of the WSS 2.0 Administrator's Guide,
> titled "Enable Windows authentication for SQL Server".
>
> Point 6 reads : "Under Authentication, select Windows only".
>
> I don't want to use SQL Server authentication in
> "Windows only" mode as that would interfere with
> other web applications I have running.
>
> Will "Mixed mode" ( SQL Server *and* Windows )
> authentication allow me to install WSS 2.0 correctly ?
>
>
>
> Juan
> ===
>
>

Relevant Pages

  • Re: MSDE does not work for XP power user
    ... the security is set to 'SQL Server security' and the default user's ... You need to explicitly enable it during installation or after installation, until then, the "sa" user name and password cannot be used to connect to SQL Server MSDE. ... Or look into registry to determine if mixed mode is enabled. ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE does not work for XP power user
    ... the security is set to 'SQL Server security' and the default user's ... You need to explicitly enable it during installation or after installation, until then, the "sa" user name and password cannot be used to connect to SQL Server MSDE. ... Or look into registry to determine if mixed mode is enabled. ...
    (microsoft.public.sqlserver.msde)
  • 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: 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)