Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SharePoint 2007 database connectivity issue

Posted on 2011-02-12
9
Medium Priority
?
496 Views
Last Modified: 2012-05-11
Hi,

I have 2 server farm setup of Moss 2007:
1 WFE
2. DB server.

We have delivered multiple simple sharepoint sites on this server since last many months and everything was fine perfectly fine.
But suddenly yesterday when browsing any of the moss site, it kept asking for credentials and never eventually opened it.
I digged into the event logs of WFE and found following errors there:
1. Event ID:7888 and event ID:3355

Both of them talked about issue connecting with sql server. Our db server is working fine and i am able to ping it from WFE as well.
Moreover nothing special has happened on these servers (updates/config changes/farm credentials etc.),though we did deployed a simple moss collaboration site couple of days back,but that too is not exposed to public, so no issue of memory leaks could be there as well.

While browsing the net, most of the people seems to be suggesting to upgrade the sql server2005 to SP2, but i am not able to find the reason why should i do that,bcoz everything was working fine earlier as well??

On db server following error is coming:
Event ID:17310

I even just found that we are fast running of disk space on db server and have only 700MB of space left there. When i digged and have just found that db log size have increased to more than 20 GB, Can this be an issue? can i clear the  db logs, will that cause any impact on app.?

I am not able to access any of the application, not even central admin.

Can you please provide pointers on how to resolve the same?

0
Comment
Question by:navtej_dhillon
[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 51

Expert Comment

by:Ted Bouskill
ID: 34881571
Clear the logs and in fact I'd recommend you switch the database to the 'Simple' recovery model to avoid generating such large files.  Transactional database restores aren't safe in SharePoint and unless you are using a product specifically designed for recovery in SharePoint the transactional logs are useless.

Are you backing up your non-Administration databases frequently?
0
 
LVL 5

Author Comment

by:navtej_dhillon
ID: 34882143
I will definately compress/limit the log file size. These log files are db logs and not moss logs.
I restarted my WFE and sharepoint is back up and running, but i could still see same error in db server event logs (event ID: 17310).

I am still trying to figure out root cause for same. Can this behavior be due to some memory leaks?

Any pointers on how to mitigate/resolve this issue?

Restart desn't seems to be the solution to me, as this error can again come back to haunt us.

~Amit
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 34883378
If you haven't been applying the latest Windows Server service packs nor the proper Sharepoint updates (in order) then these types of errors are almost impossible to remove.

By the way, the SharePoint Usage Tracking/Logging adds a LOT of data.  Accumulated over years it can overwhelm a server.

What maintenance are you executing on the server?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 5

Author Comment

by:navtej_dhillon
ID: 34885824
There is no maintenance exercise going on server, it just happened automatically.

We have found the reason for this issue.
Issue is that search has hanged while crawling which has created all mess.
But now i am unable to stop the crawling of search as well,and status is showing as "FULL Crawling".

I tried restarting the search services, trying to stop the crawl from central admin and stsadm command, but no avail.

I read that it is a known moss bug and was solved in this fix http://support.microsoft.com/default.aspx?scid=kb;EN-US;956056, but our moss installation is already of higher version (12.0.0.6520)

Any clues on how can search be stopped from crawling.
This search crawling is creating a lot of sql dumps which in turn is consuming all of HDD space as well.

~Amit
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 34885849
I'm sorry I wasn't clear.  I wasn't asking if you executed maintenance to cause this problem I was asking if you have been doing scheduled maintenance (past tense) on the server.

I've experienced this exact problem and I'm sorry to say it's a very bad one and preventing it requires applying the Windows Server and SharePoint Updates and Service Packs in the correct order.  That is very key.  Sadly not all of the updates in MOSS 2007 are cumulative and skipping a previous update means that the update wasn't applied and cannot be because the schema is now a newer version.

I'm sorry to say that I think you should contact Microsoft Support.  Your farm is in jeopardy of permanent harm and might require a rebuild.
0
 
LVL 5

Author Comment

by:navtej_dhillon
ID: 34994621
We have finally being able to resolve this issue. This was a product bug and was an issue with preserving of duplicate index key. I got a root cause of issue from following article:
http://blogs.vertigo.com/personal/Michael/Blog/Lists/Posts/Post.aspx?ID=4

Kudos to him for pointing the root cause, but instead of taking the steps which he mentioned, i read in one of the MS service packs that this used to be a known issue and got resolved with service pack.
So i went ahead and installed SP3 of Sql server 2005 and restarted the server.
Amazing all the issues got resolved. Now search is working perfectly on server.


~Amit
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 34994686
OK, do not under any circumstances every tell Microsoft that you touched the schema directly.  It means you void all future support.  I know this first hand.  They would have done the same thing as you but it would have been MS approved.
0
 
LVL 5

Accepted Solution

by:
navtej_dhillon earned 0 total points
ID: 35381370
Yeah, we didn't wanted to do that as well, so we took the article as reference only just for finding the root cause. Finally we did figured out that this sql issue was solved in SP3 of Sql Server, so we just applied that service pack and have not done any changes to schema.

~Amit
0
 
LVL 5

Author Closing Comment

by:navtej_dhillon
ID: 35872813
SOLVED MYSELF
0

Featured Post

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

610 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