SharePoint 2007 database connectivity issue
Posted on 2011-02-12
I have 2 server farm setup of Moss 2007:
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:
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?