Facing SQL Connection ERROR : Unable to reach database serve

Posted by Community Admin on 04-Aug-2018 09:53

Facing SQL Connection ERROR : Unable to reach database server on host ''.

All Replies

Posted by Community Admin on 13-Nov-2014 00:00

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

Posted by Community Admin on 18-Nov-2014 00:00
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
 
Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
 
This thread is closed