Re: Regarding setup for SharePoint Services 2.0...

• Previous message: : "Re: Regarding setup for SharePoint Services 2.0..."
• In reply to: Mike Walsh: "Re: Regarding setup for SharePoint Services 2.0..."
• Messages sorted by: [ date ] [ thread ]

Date: Sun, 23 Jan 2005 12:43:55 -0400

So, that means it's OK to set up SQL Server
authentication as mixed mode when installing WSS ?

Juan T. Llibre
==========
"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:eNO%23bSSAFHA.2104@TK2MSFTNGP14.phx.gbl...
> 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
>> > ===
>> >
>> >
>>
>>
>
>

• Previous message: : "Re: Regarding setup for SharePoint Services 2.0..."
• In reply to: Mike Walsh: "Re: Regarding setup for SharePoint Services 2.0..."
• Messages sorted by: [ date ] [ thread ]