Solved

Sharepoint "Unable to connect to database"  error 823287

Posted on 2006-11-20
9
8,372 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
  • 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
 
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now