Solved

Sharepoint "Unable to connect to database"  error 823287

Posted on 2006-11-20
9
8,620 Views
Last Modified: 2008-01-09
Had a server hang this morning during a backup, and had to hard reboot the server.
SBS 2003 SP1, sharepoint sp2.  Everything was working great, until the hard reboot, and now i'm getting the abovementioned error when i try to open companyweb.

The database appears to be running fine, but i can't access companyweb -i get the error

I go away for two weeks in the next couple of days, so i'm very motivated to resolve this.


-c
0
Comment
Question by:cetomas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 17983681
823287 is actually the KB article you need to look at when this error comes up.  http://support.microsoft.com/kb/823287

Jeff
TechSoEasy
0
 
LVL 1

Author Comment

by:cetomas
ID: 17983727
I've done some further poking around and found that the database is being marked as suspect....

Pretty much the exacts same problem as this thread http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21667727.html 
BUT i'm using MSDE and not SQL.

I need an equivelant way to get into the MSDE sharepoint database in emergency mode, as i don't have query analyzer.
So i need to do this in OSQL possibly but i minimal history with using that tool.

I'm pretty desperate here, just discovered that the sharepoint site hasn't been backing up correctly, i've just been watching backup reports but not looking closely enough to actually test restoring, anyways, very bad on my part, but I need help in a major way!!!!

If it was possible, i would give 10 000 points to the person who can help me fix this asap

-c
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 17983959
Tell you what... try doing this, which may help to fix the problem immediately...

Remove the SharePoint extensions from the companyweb virtual server and then reinstall them.  Usually this will fix the problem.

If you need help as to how to do this, please advise.

Jeff
TechSoEasy
0
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 
LVL 1

Author Comment

by:cetomas
ID: 17984111
yeah i don't know how to do that... would love some help.

thanks jeff

-c
0
 
LVL 1

Author Comment

by:cetomas
ID: 17984352
hey jeff,

I tried removing sharepoint from the companyweb virtual server (using sharepoint central admin)
then i go back in to configure virtual server settings, select companyweb, and then choose "extend and map to another virual server", at which point i chose "use an existing application Pool", selecting MSSharepointAppPool (NT Authority\System).   After this i try accessing companyweb and i get the same error.

Should i be choosing, "extend and create a content database"
Or am i missing a step in the first method?

-chad
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
ID: 17984392
Actually you want to use the Default Application Pool.  See the steps at the bottom of http://support.microsoft.com/kb/829113

Jeff
TechSoEasy
0
 
LVL 1

Author Comment

by:cetomas
ID: 17986097
Well...late in the evening/early morning i'm back up.  

Thanks for pointing me in the right direction jeff....solution was a bit different.

I was able to grab a volume shadow copy of the mssql$sharepoint folder from the weekend.  (to use the "client software" to access this at the folder level i shared the folder, browsed to \\localhost\ and then looked at the properties of my shared mssql$sharepoint folder, went to previous versions and then copied the most recent version (before the damaged db) to another volume.

I made the mistake of replacing the whole directory at first and trying to just start it back up, (not just the 4 .mdf and log files as mentioned in the bottom article link below). If i would have done that at that point, i may have avoided a few steps....This is what led me to have to do the reinstall of sharepoint.


I ended up having to reinstalled intranet (sharepoint).  Used this info to help with that:
 http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.windows.server.sbs&tid=f47a3e8d-4956-49cb-a03b-a204b4ae4d7a&m=1&p=1

Then i did a "disaster recovery operation" to put in the databases that i grabbed from a volume shadow copy.
http://support.microsoft.com/kb/827701/

The last few sections of the disaster recovery article did not apply, as it was for restoring onto a brand new server, with ad account references from the config db being out of whack.  

The last step was applying sharepoint sp2 (companyweb was showing an http error 500 page cannot be displayed).  After sp2 re-apply, it all worked and i was a very happy man to see that sharepoint site backup with all of it's data and config.

I'm now testing some new backup software that i've had my eye on for awhile. (i got lucky this time kids!!)

I must same i'm thankful for the volume shadow copy that was configured auto by sbs setups.

Thanks for your help jeff, you didn't give me the exact step by step solution, but definitely pointed me in the right direction and gave me hope that i wasn't totally screwed.  full points for you.

-c

0
 
LVL 1

Author Comment

by:cetomas
ID: 17986107
hey admins.... is there a way to give jeff the points but put the "accepted answer" on my last post here?  I just want it to be clear for folks in the future with the same scary problem...
Or maybe jeff...put another post and say check out the details above for the answer and i'll accept that as the answer...

i don't know how that should work>

thanks again jeff...

-c
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 500 total points
ID: 17992345
Glad you got it going... if I had known that's where you were at, I should have pointed you to http://support.microsoft.com/kb/829114.  Oh well.

FYI, quite often, there is not a "definitive" answer in a question... but usually it's the string of responses that leads to the solution.  So accepting the last comment is generally acceptable.

Jeff
TechSoEasy
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of problems and solutions are available on the net for the error message "Source server does not meet minimum requirements for migration" while performing a migration from Small Business Server 2003 to SBS 2008. This error pops up just before …
Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question