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

Forums / Set-up & Installation / Unabale to connect to SQL Server 2005 database

Unabale to connect to SQL Server 2005 database

2 posts, 0 answered
  1. Gavin
    Gavin avatar
    20 posts
    Registered:
    06 Jul 2009
    14 Oct 2009
    Link to this post
    Hi,

    I'm trying to roll out a 3.7 Community Edition site to ASPNIX hosting.

    However I can't connect to the database. It seems Sitefinity specific as when I delete the site and set up a simple test page to connect to SQL Server using the same connection string there is no issue.

    Any ideas what the problem might be?

    The error from sitefinity.log...

    10/13/2009 9:36:14 PM [UNKNOWN]
    ************************************************************************************
    ID: a9d84dda-57b5-4b5e-8f6c-a31319a97fab; Code: 3005; Occurrence: 1; Sequence: 9
    ------------------------------------------------------------------------------------

    Application information:
        Machine name: ANAXA-WEB14
        OS Version: Microsoft Windows NT 5.2.3790 Service Pack 2
        Product Version: 3.7.2022.3
        Application Path: C:\Domains\paydirt.co.nz\wwwroot\
        Debug: False

    Process information:
        Process ID: 4228
        Process Name: w3wp

    Request information:
        Request URL: /Default.aspx
        Rewrite URL: http://www.paydirt.co.nz/Default.aspx
        Url Referrer:     Is Authenticated: False
        Authentication Type:     User:     User Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 GTB6 (.NET CLR 3.5.30729)
        User Address: 121.72.241.211

    Variables:

    - L0 -------------------------------------------------------------------------------

    Exception Type: System.Data.SqlClient.SqlException

    Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    Source: .Net SqlClient Data Provider

    Stack Trace:
       at Nolics.ORMapper.DataProviders.SQLDataProvider.Open()
       at Telerik.DataAccess.NolicsHelper.SetConnection(String connectionName, String providerName)
       at Telerik.Cms.Data.DefaultProvider.Initialize(String name, NameValueCollection config)
       at Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
       at Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings)
       at Telerik.ManagerBase`1.SetProvider(String providerName)
       at Telerik.ManagerBase`1..ctor(String providerName)
       at Telerik.ManagerBase`1..ctor()
       at Telerik.Cms.Web.UrlHelper.Initialize(CmsHttpModule cmsModule)
       at Telerik.Cms.Web.CmsHttpModule.Init(HttpApplication context)
       at System.Web.HttpApplication.InitModulesCommon()
       at System.Web.HttpApplication.InitModules()
       at System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers)
       at System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context)
       at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
       at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
    ------------------------------------------------------------------------------------
  2. Gavin
    Gavin avatar
    20 posts
    Registered:
    06 Jul 2009
    14 Oct 2009
    Link to this post
    Hi,

    Please ignore this thread, I'm not sure this is the actual error. It might be something else.

    Cheers,
    Gavin
2 posts, 0 answered