11 January, 2011

Cannot connect to SQL Server - Event 3355 (SharePoint Server 2010)

Microsoft SharePoint Foundation 2010 uses Microsoft SQL Server 2008 databases to store configuration settings and most of the content for the Microsoft SharePoint Foundation Web site.

For example, all pages in the site, files in document libraries, files attached to lists, and information in lists are stored in the content database, and security and permission settings along with other configuration settings are stored in the configuration database in SQL Server. SharePoint Foundation 2010 uses a service account to communicate with the database on behalf of a user request. This service account can be either a specific user name or password (domain name and password), or a predefined system account, such as Local System or Network Service. When a SQL Server database is created, a value for the maximum database size is set. Each database has a separate database size setting. Note that a Web application might be associated with one or many databases.

This error indicates that Microsoft SharePoint Foundation could not connect to the SQL Server database.

One or more of the following symptoms might appear:
• Attempts to communicate with SQL Server fail and no content from databases hosted on the SQL Server can be accessed.
• This event appears in the event log: Event ID: 3355 Cannot connect to SQL Server.
not found. Additional error information from SQL Server is included below.

One or more of the following might be the cause:
1. The SQL Server might be offline.
2. The SharePoint Foundation database access account might not have the necessary permissions to communicate with the SQL Server.
3. A firewall that runs on either the local server or on SQL Server might be blocking network communications.

Troubleshooting Steps:

Grant correct permissions to the database access account:
You must be a member of the Farm Administrators group to perform this task.

Assign the database access account:
a. On the Central Administration home page, click Security and in the General Security section click Configure service accounts.
b. On the Service Accounts page, in the Credential Management section, in the upper dropdown list click the correct Web application pool for your Web application.
c. In the Select an account for this component drop-down list, click the domain account that you want to associate with this Web application pool, or click Register new managed account to associate a new domain account with this application pool.
d. Click OK to save changes.

Verify that the account has correct permissions in SQL Server:
a. Connect to the computer that runs SQL Server by using an account that has Administrator permissions.
b. In SQL Server Management Studio, Object Explorer navigation pane, expand the Security node, and then expand the Logins node. The name of the database access account indicates that it is a SQL login.
c. If the account exists, in the Object Explorer navigation pane, expand the Databases node, expand the configuration database node, expand the Security, and then click Roles.
d. Expand the Database Roles node, right-click db_owner role and select Properties.
e. In the Database Role Properties dialog box, check whether the database access account is in the Members of this role list. If the account is not listed, click Add.

If you have any queries or questions regarding the above mentioned info then please let me know, Thanks...



6 comments:

  1. Hi,

    I have already tried above steps. But still I am getting same issue. Sometimes I am also getting 7888 and 10036 errors with event id 3355.

    Pl. help..!!

    ReplyDelete
  2. I had faced a similar problem in the past after following all the steps and found this one, that resolves my issues

    http://blogs.vertigo.com/personal/michael/Blog/Lists/Posts/Post.aspx?ID=4

    Please check and let me know in case of any issues,Thanks for your patience

    ReplyDelete
  3. Hi Amol,

    The said link is for crawl issues. I am getting issues like "cannot connect sql server". The event Ids are 3355, 7888, 5586 etc.

    Pl. let me know if you have any idea.

    Thanks.

    ReplyDelete
  4. database communication issue / cannot connect sql server
    Event viewer -3355, 7888, 10034, 27745 errors.

    Troubleshooting steps that we can try:

    1. On your database server, try to activate both TCP/IP and Named pipes through your surface area configuration tool.
    Don't forget to restart your sql server service, once done

    2. Please check the firewall between your web front end and your database server.

    3. start SQL Server Browser service on Database Server

    Please refer this: http://blogs.technet.com/b/wbaer/archive/2009/10/06/intermittent-database-server-connectivity-and-microsoft-sharepoint-products-and-technologies.aspx

    ReplyDelete
  5. Hi,

    Checked everything and followed steps. Still same error. I have also reconfigured application but no luck. :(

    Regards,
    Dhaval

    ReplyDelete
    Replies
    1. Could you please share the logs so that we can check and do some analysis? Thank you.

      Delete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.