Re: WSS Installation problem, please help!

Just to let you know, I finally got the Central Administration page to come
up. I had to add my Application Pool account to the local STS-WPG and IIS_WPG
groups. I'll keep trudging along and let you know if I run into anymore
hiccups. Thanks for the help.

"FombyJambox" wrote:

Sorry for not being more clear. I am really out of my element with this
entire WSS and SQL setup, but unfortunately it's on me to figure it out. So
to hopefully provide the specifics you need, I checked the security tab in
SQL Enterprise Manager and it is set to 'SQL Server and Window'. According to
the help file this is considered Mixed mode. I hope this is the information
you meant.

"Engelbert" wrote:

I was answering the question you posed

(I know that windows authentication is 'recommended' when using SQL server
for a WSS configuration, but is it possible to use SQL authentication?)

You haven't in any case said anywhere in the text (or now) whether you used
mixed or SQL authentication.

SQL Authentication won't work.

Mixed or windows will.

Engelbert


"FombyJambox" <FombyJambox@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9E91A230-6FC5-422C-9065-080B6266C0AD@xxxxxxxxxxxxxxxx
Any insight on what my problem may be then?

"Engelbert" wrote:

You can use mixed.

Engelbert

"FombyJambox" <FombyJambox@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3B084340-1A47-42B9-A0C4-F0E3B09E56A2@xxxxxxxxxxxxxxxx
I know that windows authentication is 'recommended' when using SQL
server
for
a WSS configuration, but is it possible to use SQL authentication? I am
trying to install WSS on an existing win2003 server running SQL 2000
SP3.
I
installed WSS using remotesql=yes and since it completed I haven't
been
able
to log into the central adminstration page. Initialy I was being
prompted
3
times and then kicked to the error page. I found a thread about the
pool
account requiring write access to the Temp ASP NET folder and granted
those
rights. Now I simply get 'Service Unavailable'. I have tried using the
account that was used to install WSS, a newly created domain account,
and
a
local account. I can start the StsAdminAppPool and it will fail each
time
I
try to access the site again. I am not sure if I need to do somthing in
SQL
Enterprise Manager to allow for the creation of the DB's, could that be
what
I am overlooking? Each time the pool fails I get the following error in
event
viewer:

A failure was encountered while launching the process serving
application
pool 'StsAdminAppPool'. The application pool has been disabled.

I have been searching and reading threads in this newsgroup all day but
to
no avail. I think at this point I have thouroughly confused myself
reading
posts that cause me to search for more and more clues. I am new to WSS
and
could really use a help getting pointed in the right direction. Thanks
in
advance.






.

Relevant Pages

  • Re: Site full text not functioing
    ... For WSS, we use SQL Full Text search. ... Find out if the SQL Server account has permissions to that folder if the error message indicates a folder on the hard drive. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Problems adding users
    ... I had to do some SQL surgery this afternoon that may or may not help. ... A domain username was ... First we tried to rename the user, but WSS ... >> account in the AD was never deleted, the account name for this user was ...
    (microsoft.public.sharepoint.windowsservices)
  • WSS SQL SERVER LOGIN QUESTION - Only sa can login to SQL
    ... I just setup a second server with SQL 2000 and WSS 2.0. ... Not even my administrator account ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: WSS Installation problem, please help!
    ... entire WSS and SQL setup, but unfortunately it's on me to figure it out. ... SQL Enterprise Manager and it is set to 'SQL Server and Window'. ... SQL Authentication won't work. ... account requiring write access to the Temp ASP NET folder and granted ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Active Directory Account Creation Mode does not work
    ... Unfortunately there is no WSS OOTB solution. ... account provisioning solution rather than using AD Account Creation Mode. ... >>Hi Randy, ... >>that the app pool must be running under a domain account, ...
    (microsoft.public.sharepoint.windowsservices)