Re: Regarding setup for SharePoint Services 2.0...

From: Mike Walsh (englantilainen_at_hotmail.com)
Date: 01/23/05 

Date: Sun, 23 Jan 2005 10:21:57 +0200

For what it's worth I've just done a Project Server 2003 installation
following the single-server installation guide for that product. When it got
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 (next step)
to install WSS.

Something to consider when wondering if MS will continue to support mixed
mode or when wondering if mixed mode is a solid solution.

(Until this installation I would have had the same opinion as you ...)

Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.

"<Todd />" <todd@N*O*S*P*A*M*mindsharp.com> wrote in message
news:OXKv5RRAFHA.4044@TK2MSFTNGP14.phx.gbl...
> 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...
    ... 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: Problems installing Sql Server 2005 Developer Edition "Setting
    ... It may happen on any SKUs including SQL Server 2005 Express ... SQL Server 2005 Setup needs to configure security settings. ... LookupAccountName() may take much longer time and cause Setup ... sooner, return the control back to SQL Setup, and let installation continue. ...
    (microsoft.public.sqlserver.setup)
Loading