+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Facing SQL Connection ERROR : Unable to reach database server on host ''.

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

2 posts, 0 answered
  1. Priyanka
    Priyanka avatar
    1 posts
    Registered:
    13 Nov 2014
    13 Nov 2014
    Link to this post

    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 : http://lcd.webfarm-uat.ms.com:16110/lcdportal/ExtApp/GenericUISubmission.aspx?page=infopage
    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

  2. Junior Dominguez
    Junior Dominguez avatar
    115 posts
    Registered:
    08 Dec 2016
    18 Nov 2014
    Link to this post
    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
     
2 posts, 0 answered