Facing SQL Connection ERROR : Unable to reach database server on host ''.
Hi,
We have recently migrated our application from IIS6 to IIS7.5. Now we are facing issues while connecting to Sitefinity post any Page submission.
Below is the error we are receiving. Please suggest on this.
Message: HandlingInstanceID: 60a23950-0e86-4312-b057-bb8b7cdd7079
An exception of type 'Telerik.OpenAccess.Exceptions.DataStoreException' occurred and was caught.
------------------------------------------------------------------------------------------------
11/12/2014 02:03:32
Type : Telerik.OpenAccess.Exceptions.DataStoreException, Telerik.OpenAccess, Version=2011.2.713.3, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342
Message : Unable to reach database server on host ''.
Error Details:Error executing query: Telerik.OpenAccess.RT.sql.SQLException: A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
SQL:
SELECT [date_created] AS COL1, [last_modified] AS COL2, [voa_version] AS COL3 FROM [sf_page_node] WHERE [id] = ?
Source : Unity_ILEmit_DynamicClasses
Help link :
InnerExceptions : System.Exception[]
FailedObject :
BackendError : Telerik.OpenAccess.RT.sql.SQLException: A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
Reason : HostnameUnresolvable
CanRetry : True
Data : System.Collections.ListDictionaryInternal
TargetSite : Void ChangeParent(Telerik.Sitefinity.Pages.Model.PageNode, Telerik.Sitefinity.Pages.Model.PageNode)
HResult : -2146233088
Stack Trace : at DynamicModule.ns.Wrapped_OpenAccessPageProvider_5c42e28fa2ee4223ae04cb4f28eac7ff.ChangeParent(PageNode childNode, PageNode newParent)
at Telerik.Sitefinity.Modules.Pages.PageManager.ChangeParent(PageNode childNode, PageNode newParent, Boolean storeCurrentUrlAsAdditional)
at Telerik.Sitefinity.Modules.Pages.PageManager.CreatePage(PageNode parentPage, Guid pageId, NodeType nodeType)
at LCD.CommonUI.PageInitializer.CreatePage(Guid pageId, String pageName, Guid parentPageNodId, String contentType) in C:\Priyanka\Migrated_Code\Code\Foundation\Customizations\CommonUI\PageInitializer.cs:line 92
at LCDSitefinity.GenericUISubmission.Page_Load(Object sender, EventArgs e) in C:\Priyanka\Migrated_Code\Code\Instances\LCDPortal\Customizations\LCDUI\GenericUISubmission.aspx.cs:line 69
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Additional Info:
MachineName : DDWAS482
TimeStamp : 11/12/2014 7:03:33 AM
FullName : Telerik.Sitefinity.Utilities, Version=4.4.2117.0, Culture=neutral, PublicKeyToken=b28c218413bdf563
AppDomainName : /LM/W3SVC/16110/ROOT/lcdportal-3-130602488707338136
ThreadIdentity : Anonymous
WindowsIdentity : MSAD\qlcdnkwp
Requested URL : lcd.webfarm-uat.ms.com:16110/.../GenericUISubmission.aspx
Inner Exception
---------------
Type : Telerik.OpenAccess.RT.sql.SQLException, Telerik.OpenAccess.Runtime, Version=2011.2.713.3, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342
Message : A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
Source : Telerik.OpenAccess.Runtime
Help link :
ErrorCode : -1
Number : -1
ObjectId :
Description : SQLState=;A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
Data : System.Collections.ListDictionaryInternal
TargetSite : Telerik.OpenAccess.RT.sql.ResultSet executeQuery()
HResult : -2146233088
Stack Trace : at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
Category: ErrorLog
Priority: 0
EventId: 90000
Severity: Error
Title:Enterprise Library Exception Handling
Machine: DDWAS482
App Domain: /LM/W3SVC/16110/ROOT/lcdportal-3-130602488707338136
ProcessId: 15144
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Thread Name:
Win32 ThreadId:14288
Extended Properties:
Thanks,
Priyanka
Hi Priyanka,
I would like to suggest you to take a look to the following link of our online documentation about Configuring the IIS to host Sitefinity projects.
http://www.sitefinity.com/documentation/documentationarticles/installation-and-administration-guide/install-sitefinity/configuring-the-iis-to-host-sitefinity-projects
In the document, go to the section related to your OS and IIS version and make sure the hosting environment is configured according to the documentation.
Best Regards,
Junior Dominguez
Telerik