| Author |
Message |
Juan T. Llibre
Guest
|
 Posted:
Sat Jan 22, 2005 7:35 pm Post subject:
Regarding setup for SharePoint Services 2.0... |
|
|
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
=== |
|
| Back to top |
|
 |
Guest
|
| Posted:
Sun Jan 23, 2005 6:46 am Post subject:
Re: Regarding setup for SharePoint Services 2.0... |
|
|
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...
| Quote: | 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
===
|
|
|
| Back to top |
|
|
Mike Walsh
Guest
|
| Posted:
Sun Jan 23, 2005 2:21 pm Post subject:
Re: Regarding setup for SharePoint Services 2.0... |
|
|
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...
| Quote: | 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
===
|
|
|
| Back to top |
|
|
Guest
|
| Posted:
Sun Jan 23, 2005 9:58 pm Post subject:
Re: Regarding setup for SharePoint Services 2.0... |
|
|
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...
| Quote: | 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
===
|
|
|
| Back to top |
|
|
Juan T. Llibre
Guest
|
| Posted:
Sun Jan 23, 2005 10:43 pm Post subject:
Re: Regarding setup for SharePoint Services 2.0... |
|
|
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...
| Quote: | 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
===
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in