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 09:58:09 -0600

That is odd and certainly opposite of the direction that MS seems to be
going.

<Todd />

"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:eNO#bSSAFHA.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
> > > ===
> > >
> > >
> >
> >
>
>

Relevant Pages

  • RE: Server cant be seen from the network
    ... Microsoft CSS Online Newsgroup Support ... I discovered that if I turned the SQL server ... NAT issues caused with the installation of the "full" SQL ...
    (microsoft.public.windows.server.sbs)
  • Help Please with a step by step keystroke by keystroke(or Mouse) illustration on how to setup a stan
    ... the most typical for the average developer wanting to push .Net SQL driven ... did it would involve a domain server, ... client network utility force protocol encryption is NOT checked) ... Please give a complete account of the standalone CA installation as this ...
    (microsoft.public.sqlserver.security)
  • RE: Server cant be seen from the network
    ... I did allow the accounting tech to ... After the "full" SQL server was loaded, ... NAT issues caused with the installation of the "full" SQL server/services, ...
    (microsoft.public.windows.server.sbs)
  • Re: installing help for sql 2005
    ... Now i installed the sql server2005 on one of my ... server and its running fine but i am now getting an other problem which is ... installation help with snap shots because i installed the sql server 2005 ... remote connections are disabled by default. ...
    (microsoft.public.sqlserver.setup)
  • Re: Adding Full-Text Search Indexing to a Cluster
    ... Despite what you see as "Full Text Indexing is grayed out", ... HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL ... Then using your SQL Server 2000 installation CD re-install via "Custom ...
    (microsoft.public.sqlserver.fulltext)