Re: HELP!

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Derek Martin (dmj2195_at_DONTSPAMMEokstate.edu)
Date: 05/14/04


Date: Fri, 14 May 2004 08:39:30 -0500

Okay, I'm not on the wrong screen - it is just being dumb! It says on this
page:

If you specifiy an existing databse that contains sites, those sites will be
restored and connected to this server farm.

So what am I missing?

Stressed,
Derek

"Derek Martin" <dmj2195@DONTSPAMMEokstate.edu> wrote in message
news:OhDobgbOEHA.2944@TK2MSFTNGP10.phx.gbl...
> I tried adding a Content Database and when I specify database server
> settings to the one I am trying to get at, it says this:
> A database with the given name already exists on the specified database
> server...well duh!!! So how come it won't let me connect to it?!
> hehe - I must be on the wrong screen
>
> Thanks,
> Derek
>
>
> "SizzleMaster" <larry@datasculpting.com> wrote in message
> news:%23S5VQMWOEHA.2704@TK2MSFTNGP10.phx.gbl...
> > 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: Automating Bkp & restore from command line
    ... > specifiy to wich DB the script must connect before doing th rest: ... To specify a server, you use the -S switch for OSQL. ... > So I wrote a small script in QA and thought if possible to runnit from ... > RESTORE DATABASE Test ...
    (microsoft.public.sqlserver.tools)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)