[itdiscuss] SharePoint Gurus?

[Bobby Stewart]

OK, after TOO many hours of looking at this thing I think I've got it
sorted out. The kicker is, I don't know how it got broken!

 

Over the years that SharePoint has been running in our environment I've
never altered the core server configuration since I got it up and
running. However, I've always been curious about the number of databases
that seem to be related to SharePoint but that I didn't know why they
were there or how they got there (deep magic, I'm sure). From time to
time I've had to correct permissions related issues by manually deleting
users from the SharePoint users database that weren't showing up in the
web GUI. So, I knew where the active SharePoint database was. I just
figured that the other databases had some other role I didn't understand
and - as long as it worked - I didn't care!

 

Then, this problems occurs. I STILL don't know what triggered it. I
followed the procedure at the article posted but was getting the
response "Value does not fall within the expected range" when running it
against the database specified as the content database in the SharePoint
Central Administration console under Virtual Server Management. I didn't
see that in the list of normal responses so I thought it must mean that
there wasn't a problem with this database.

 

After a long conversation with a "SharePoint expert" technician where he
told me he would have to go off and research it and come back with an
answer tomorrow, I decided to take your advice, Dayron, and do the
procedure again. So I started with the same database in the CLI as
before with the same result. I continued to follow the procedure,
removing and adding back the configuration database. Still no joy. But,
I couldn't help but wonder, why did that database have no "sites" in it?
The other database, the one with the user content, had a site and it was
appropriately named. What if I run the CLI command on it? Viola! The
result described in the article!

 

Now what? Well, it's already broken, let's get crazy. What would happen
if I substituted the database with the user data in it for the
configuration database in the administration console? Drum roll, please!
TA-DA!!! Back to the browser, reload the page and all appears to be
well. A big sigh of relief!

 

The moral of the story is, "Weird stuff happens!"

 

Side note: If it hadn't been for SQL Server Enterprise Manager, I'd
still be puzzling at it. LONG LIVE Enterprise Manager (or its current
equivalent)! It's helped me greatly with Shelby too.

 

Bobby

 

From: discuss-bounces at itdiscuss.org
[mailto:discuss-bounces at itdiscuss.org] On Behalf Of Danny Ybarra
Sent: Monday, February 22, 2010 2:47 PM
To: IT Discussion Forum
Subject: Re: [itdiscuss] SharePoint Gurus?

 

Start with event logs on the wss server and the sql server.  The usual
suspects of these type of problems are password changes for service
accounts. 

Since you said it was remote use telnet for checking that the ports are
still open over the firewall.

After that on the wss management make sure that wss is pointing to the
db server.

 

 

 

 

Danny Ybarra | ViantSolutions

IT Consultant

mailto:DannyY at viantsolutions.com <mailto:DannyY at viantsolutions.com> 

office:         678.889.6089 x103

mobile:      678.358.4603

 

From: discuss-bounces at itdiscuss.org
[mailto:discuss-bounces at itdiscuss.org] On Behalf Of Bobby Stewart
Sent: Monday, February 22, 2010 3:27 PM
To: IT Discussion Forum
Subject: [itdiscuss] SharePoint Gurus?

 

I've got a sticky SharePoint problem. We use WSS 2.0 on Win 2003 R2 with
SQL 2000 on a remote server. This weekend, after working almost
flawlessly for years, we started getting the message "The Web site that
is referenced here is not in the configuration database" when browsing
to the SharePoint site.

 

Anyone got any pointers?

 

Bobby Stewart
Network Analyst
Brentwood Baptist Church
Brentwood, TN
WWW.BrentwoodBaptist.com
(615) 324-6149 office

(615) 830-0012 cell

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://optimus.thompsonic.com/pipermail/discuss/attachments/20100222/4f46f683/attachment-0001.htm