locked
Unable to connect to the SQL content database from sharepoint web front server. RRS feed

  • Question

  • Hi,

    SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

    SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

    when ever these errors occur in eventvwr sharepoint will not work.

    Please suggest on this issue.

     

     

    Regards,

    v235.

     

     


    • Edited by Mike Walsh FIN Thursday, April 7, 2011 5:03 AM waiting for MS replies.. removed. Just post the question and let anyone reply in their own time. (Avoid "waiting for" which is unnecessarily pushy)
    Thursday, October 7, 2010 12:01 PM

Answers

All replies

  • Can you connect to content/config Databases from WFE under SharePoint Web Farm account? Try to do this from SQL Server management Studio.

     


    Oleg
    Thursday, October 7, 2010 1:36 PM
  • It sounds like a service account issue. Either the account was disabled, deleted, locked out, or the password has expired.

    You can troubleshoot this by manually connecting to SQL as Oleg described by opening SQL Server Management Studio and using the service account credentials.  This is usually the same credentials that your web application pool is currently using, also known as the Application Pool Identity.


    http://donahoo-development.com
    Thursday, October 7, 2010 1:52 PM
  • Hi all, thanks for reply...

    account was not disabled.. we are able to connect to SQL server through the account on which application poll is running. we used to take back of SQL database with that account.

    We are using single account on which sharepoint services are running, using same account SQL also configured in SharePoint configuration wizard.

    In WFE we are getting these event error, is it because of SQL is over loaded ?? or due to any other issues WFE is unable to reache the SQL databases during that time??

     

    --------------------

    v235

     

     

    Friday, October 8, 2010 10:44 AM
  • Hi V235,

    Could you tell us if the problem happens always at the same period of the day (each morning around 8 o'clock) ?

    Could you tell us if the problem happens only under heavy load ?

    Are you under a virtualize environnement ?

    You should read this article from Bill Baer http://blogs.technet.com/b/wbaer/archive/2009/10/06/intermittent-database-server-connectivity-and-microsoft-sharepoint-products-and-technologies.aspx, you will find a lot of information about Intermittent connectivity to a database server hosting Microsoft SharePoint Products and Technologies.

    Mario


    Mon Blog/My Blog (in french) LinkedIn
    Friday, October 8, 2010 12:33 PM
  • Are you sure that account is not disabled, deleted, locked out, or the password has expired?

    I got this kind of error because of the service a/c password was expired.

    pls check SQL server log size.


    thanksArup MCTS - SharePoint

    Play Sudoku Online
    Friday, October 8, 2010 12:37 PM
  • did you follow this instruction http://technet.microsoft.com/en-us/library/cc561047(office.12).aspx and key thing is run IIS reset?

     

    and also this one http://technet.microsoft.com/en-us/library/cc561042(office.12).aspx.

    One thing did you check your SQL server data drive have enough space, and also make sure Database is not offline or readonly.

    are you able to get your central admin site?

    hope this help

    thanks

    -ws

     


    SharePoint administrator, MCTS,MCITP
    Friday, October 8, 2010 12:48 PM
  • Hi Mario, Arup... thanks for reply...

    Its occurring for every 20min, the servers are in virtual environment. Load is consistent through out the day.

    @Arup, account is working fine. Once long back it has been locked out for 5 mins, after that its unlocked then sharapoint is working as of normal. Suddenly from yesterday we are getting these errors in eventvwr.

    locking the account for certain duration causes any long run problems??

     

    ----------------

    regards

    v235

     

    Friday, October 8, 2010 12:50 PM
  • locking the account for certain duration causes any long run problems??

    Answer to your questions: definitely not..

     

    Can you pls paste the error that you get in eventvwr?


    thanksArup MCTS - SharePoint

    Play Sudoku Online
    Sunday, October 10, 2010 10:28 AM
  • Hi Arup, thanks for reply..

    This is 3355 event id error.

    Cannot connect to SQL Server. SERVER_Name not found. Additional error information from SQL Server is included below.

    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

     

    -----------------------------------------------

    The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database WSS_Content_PROD on SERVER.  Check the database connection information and make sure that the database server is running..

    ---------------------------------------------------

    Unknown SQL Exception 233 occured. Additional error information from SQL Server is included below.

    The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following:  the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)

    ---------------------------------

    These are the errors which are occurring repeatedly in the eventvwr. 

    Is there any problem from SQL server side or Network side.

    No recent updates of sharepoint, SQL and OS (windws 2003 server).

    --------------------------------------------------

    regards

    v235

     

     

    Monday, October 11, 2010 9:58 AM
  • it may be bacause of the following:

    sql aliases you setup for your nonstandard sql port back when you were running SP2003.  It appears that MOSS does not like the sql alias.  On all of your WFEs, you may ran c:\WINDOWS\system32\cliconfg.exe and removed the Alias entries.  Hope this helps someone solve their errors...

     

    Make sure all your credentials are up to date. Sometimes the farm account is a domain account who's password has expired or changed. To set curent credentials, see this post:

    http://blogs.msdn.com/joelo/archive/2006/08/22/712945.aspx 

     

    Check memory space of your SQl server..

    check the link also

    http://www.thesug.org/mossasaurus/wiki%20pages/event%20id%2027745.aspx

     


    thanksArup MCTS - SharePoint

    Play Sudoku Online

    • Marked as answer by Stanfford Liu Friday, October 15, 2010 5:02 AM
    Monday, October 11, 2010 1:12 PM
  • Hi Arup,

    SQL and WFE restart helped me. during that time few sites of huge content are moving from one location to other location in same site collection. Same is noted in the Eventvwr.

    May be above suggestion will help in some cases.

     

     

    ---------------------------------

    Regards

    V235

    Tuesday, October 26, 2010 8:25 AM