Home ›
ASP.NET Forums » Starter Kits and Source Projects » Community Starter Kit » error: 40

error: 40

Last post 01-26-2006 3:20 AM by Thomas Stone. 2 replies.

Sort Posts:

  • error: 40

    01-25-2006, 6:29 AM
    • Member
      100 point Member
    • Thomas Stone
    • Member since 04-07-2005, 4:33 PM
    • Posts 22

    PLEASE help me with this error message:

    An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    Thanks!

  • Re: error: 40

    01-25-2006, 2:17 PM
    • Contributor
      4,482 point Contributor
    • jodywbcb
    • Member since 03-12-2003, 3:52 PM
    • West Seattle,WA
    • Posts 985
    You are either using SQL Express or SQL 2005 - you need to run the Surface Area Configuration and enable TCP for SQL.  This is default behavior for a fresh install of it...

    >Programs
    >Microsoft SQL Server 2005
    >Confiuguration
    >Surface Area Configuration



    -- jody
    My Blogs on .Net 2.0 and Ajax
    http://csk.wbcb.com
    http://ArtbyJody.com

  • Re: error: 40

    01-26-2006, 3:20 AM
    • Member
      100 point Member
    • Thomas Stone
    • Member since 04-07-2005, 4:33 PM
    • Posts 22
    Great Jody, thanks!
Page 1 of 1 (3 items)
RSS Available

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.