Cannot connect to SQL server. SQLServer... not found. Additional error information from SQL ... Timeout expired
Error Message :
Cannot connect to SQL server. SharePointSQLServer not found. Additional error information from SQL server is included below. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Possible Fix :
Fix 1:
Verify service accounts to application pools
* Go To Central Administration > Operations > Service Accounts.
* Select Web Application Pool .
* Select Windows SharePoint Services Web Application from the drop down under Web Service.
* Go through each application pool and note the UserName. Compare these names with log on identity of the application pools in IIS on each SharePoint servers.
They should all be the same.
Fix 2:
Reset Database-connection-timeout
Follow http://technet.microsoft.com/en-us/library/cc263314.aspx and change the timeout to 45.
stsadm -o setproperty -pn database-connection-timeout -pv 45
Check http://blogs.technet.com/wbaer/archive/2009/10/06/intermittent-database-server-connectivity-and-microsoft-sharepoint-products-and-technologies.aspx
Cannot connect to SQL server. SharePointSQLServer not found. Additional error information from SQL server is included below. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Event ID: 3355
Possible Fix :
Fix 1:
Verify service accounts to application pools
* Go To Central Administration > Operations > Service Accounts.
* Select Web Application Pool .
* Select Windows SharePoint Services Web Application from the drop down under Web Service.
* Go through each application pool and note the UserName. Compare these names with log on identity of the application pools in IIS on each SharePoint servers.
They should all be the same.
Fix 2:
Reset Database-connection-timeout
Follow http://technet.microsoft.com/en-us/library/cc263314.aspx and change the timeout to 45.
stsadm -o setproperty -pn database-connection-timeout -pv 45
Check http://blogs.technet.com/wbaer/archive/2009/10/06/intermittent-database-server-connectivity-and-microsoft-sharepoint-products-and-technologies.aspx
0 comments:
Post a Comment