Re: HELP!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: SizzleMaster (larry_at_datasculpting.com)
Date: 05/14/04 

Date: Thu, 13 May 2004 20:25:12 -0700

Yeah that's a bit screwy that you're not given the option to extend and
connect to existing config db. I'd try extending and creating a new db and
then go in and change the db once extended.

I'm not sure if the artivle below applies to what you've done but given the
ordering you should check it out.

http://support.microsoft.com/default.aspx?scid=kb;en-us;824877

Also, SPS and WSS should share the same app pool if they're running on the
same server.

"Derek Martin" <dmj2195@DONTSPAMMEokstate.edu> wrote in message
news:e80j18VOEHA.308@TK2MSFTNGP11.phx.gbl...
> Well, okay, I have been able to connect to the configuration database, not
> sure what happened, but it decided to start working after a couple of
> reboots. Now, I need to extend a virtual server and map that to a
> pre-existing content database...when I click to extend, the two options it
> gives are to Extend and Create or Extend and Map to existing - since no
> other virtual servers exist, I can't map, but I can't extend and create
> either, that won't do, so how do I reconnect to an existing content db, or
> do I need to get SPS installed now and go that route??
>
> Thanks,
> Derek
>
>
> "SizzleMaster" <larry@datasculpting.com> wrote in message
> news:efL4foVOEHA.892@TK2MSFTNGP09.phx.gbl...
>> This confuses me. When do you get this error? I think I understand
> roughly
>> what's happening here. If you're using the sa to restore the
> configuration
>> db, a db that was created using Windows Authentication, not SQL
>> authentication or mixed mode then you might recieve this error because
>> the
>> sa is the SQL admin account. It isn't a Windows or AD account and so by
>> using the sa to restore, its stating that you'd have to change your
>> authentication mode for the db from what it probably is, windows
>> authentication. Don't use the sa to restore, use the sa to access the db
>> and give rights to a windows account that you'll use for the restore. I
>> have no idea why your original account isn't working so that's troubling
> but
>> this might be a solution.
>>
>> "Derek Martin" <dmj2195@DONTSPAMMEokstate.edu> wrote in message
>> news:%23YLb8zUOEHA.2996@TK2MSFTNGP12.phx.gbl...
>> >
>> > Hi again, thanks for the tip - I tried the sa account, which did
> let
>> me
>> > in (thank goodness), but now this error which I have not seen before:
>> >
>> > You cannot change the SQL Server authentication mode of an
> existing
>> > configuration database. You must use the same authentication mode that
>> was
>> > used when the configuration database was created.
>> >
>> > Now, if this is the mode that is defined on the same screen
> (create
>> AD
>> > accounts or not), then the error shouldn't be appearing because all of
> my
>> > users are already set up in AD and they always were in AD before
> whatever
>> > happened, uh, happened.
>> >
>> > So, do you know what this little warning might be about if it
> isn't
>> > the AD mode thing????
>> >
>> >
>> >
>> > Thanks so much, man this sure is a mess!
>> >
>> > Derek
>> >
>> >
>> >
>> >
>> > "SizzleMaster" <larry@datasculpting.com> wrote in message
>> > news:OYtpOvUOEHA.2780@TK2MSFTNGP09.phx.gbl...
>> > > You could try using the sa account to connect to the config DB. I'm
> not
>> a
>> > > SQL expert at all but I seem to remember not being able to access
>> > > some
>> > db's
>> > > in SQL using the domain\administrator "god" account as you say. In
> SQL,
>> > the
>> > > sa is god. You could also create a new config db if that doesn't
> create
>> > too
>> > > much hasle for you. Sorry I can't help more. Sounds like a mes.
> Good
>> > > luck.
>> > >
>> > >
>> > > "Derek Martin" <dmj2195@DONTSPAMMEokstate.edu> wrote in message
>> > > news:%23AY$2aUOEHA.2740@TK2MSFTNGP11.phx.gbl...
>> > > > Hi there, after restarting the box, I checked the AppPool and it
>> > > > was
>> > > > correct. After going back out to the Central Administration, it
> BSOD
>> > me -
>> > > I
>> > > > couldn't get to the server screen in time to see the STOP message.
>> > > >
>> > > > So, here is what I have done:
>> > > > I reinstalled IIS, that didn't do it, same problem with Service
>> > > Unavailable.
>> > > > I reinstalled Windows and am now attempting to install Sharepoint
> Web
>> > > > Services (will do Portal when that gets up and running).
>> > > > I restored from last night's complete DB backup of our databases
> (all
>> 4
>> > > > db's).
>> > > >
>> > > > Now, I am attempting to set up sharepoint web services on the box
>> again,
>> > > > like normal, however, something is screwy still.
>> > > >
>> > > > I am getting this error when attempting to Configure Database
>> > > > (using
>> > > Connect
>> > > > to Existing Configuration DB):
>> > > > Login failed for user 'su\hrapp'. (Error code: 18456).
>> > > >
>> > > > I checked permissions on that DB in SQL and it is correct. I also
>> tried
>> > > our
>> > > > domain administrator (which has God mode over everything in the
>> domain)
>> > > and
>> > > > got the same error.
>> > > >
>> > > > Could I just be missing something totally off the wall here?
>> > > >
>> > > > Thanks so much,
>> > > > Derek
>> > > >
>> > > > "Christopher Hall [MSFT]" <chall@online.microsoft.com> wrote in
>> message
>> > > > news:eCnJpDUOEHA.2972@TK2MSFTNGP10.phx.gbl...
>> > > > > Check what identity the AppPool accounts are running under and if
>> they
>> > > are
>> > > > > even started. What user did you enter during setup for portal
>> Admin?
>> > > > >
>> > > > > Chris
>> > > > >
>> > > > > "Derek Martin" <dmj2195@DONTSPAMMEokstate.edu> wrote in message
>> > > > > news:OMsxHaSOEHA.556@TK2MSFTNGP10.phx.gbl...
>> > > > > > In the middle of setting up my portal, SPS2K3, I had to reboot
> the
>> > web
>> > > > > > server. After reboot, no anomolies, attempts to reach the
> portal
>> > give
>> > > > > this
>> > > > > > message:
>> > > > > > You cannot view this area, either because the area no longer
>> exists,
>> > > or
>> > > > > > because you do not have the rights to view this area. To change
>> your
>> > > > > rights,
>> > > > > > contact the site administrator.
>> > > > > >
>> > > > > > That is me logging in as the domain administrator (and any
>> > > > > > other
>> > user
>> > > > for
>> > > > > > that matter). Backdooring my way through Central
>> > > > > > Administration
>> > > allows
>> > > > me
>> > > > > > to get to the Users and Site Groups settings but all the other
>> > > settings
>> > > > > > gives errors like these:
>> > > > > >
>> > > > > > Access Denied
>> > > > > > Category Not Found
>> > > > > > etc.
>> > > > > >
>> > > > > > Help!!!!! Any way to recover???
>> > > > > >
>> > > > > > Thank you,
>> > > > > >
>> > > > > > Derek
>> > > > > >
>> > > > > >
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Re: Virtual Directory - Permission Denied with fso CopyFile
    ... an account I created to test this whole ... I've remove the check box for integrated authentication and I've even tried ... > configuration and common AD for trust configuration. ... > tab for the virtual directory and unchecked the windows authentication. ...
    (microsoft.public.inetserver.iis)
  • Re: Problems with Kmail
    ... to refusing the connection during authentication. ... the account, I still could not retrieve mail (yes, this was on the ... had to go into the KMail account configuration and re-enter the password. ...
    (alt.os.linux.suse)
  • Re: IIS 6 fails anonymous connection
    ... It sounded like you configured sub-authentication, which on prior IIS ... The reason that you have to have Integrated authentication enabled along ... so there is some sort of configuration problem specific to ... The resources must also be ACL'd for this user account or else you will get ...
    (microsoft.public.inetserver.iis.security)
  • Re: Basic Authentication fails with Error 401.2 where Integrated s
    ... user account then IIS will reprompt for an account that does. ... I've enabled failure logging and tested a regular remote desktop log in to ... Authentication Package: Negotiate ... the integrated authentication box in the IIS security configuration, ...
    (microsoft.public.inetserver.iis.security)
  • Help with TIdHTTPServer Authentication, please
    ... to extend the authentication from a single Username and Password to a list ... the browswer no longer brings up the Login ... dialog and just carries on without authentication. ... User, Pass: string; ...
    (alt.comp.lang.borland-delphi)