Visual Studio 2005 cannot connect to local SQLServer Express

Posted on 2006-05-18
Last Modified: 2011-09-20
I installed Visual Studio 2005.  I am trying to connect to a local SQLServer Express instnace via the VS server explorer in order to make a new database and am getting the following error:

"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)"

Gahhhh!!!!  I have tried changing settings in SQL Server configuration tool, but to no effect, and it seems that the default setting should have worked because this is a local connection, not remote.  I shut off the firewall.  Any ideas?
Question by:alisman
    LVL 11

    Accepted Solution

    try to turn on the name pipes protocol SQl Server Configuration Manager > SQL Server 2005 Network Configuration > Protocol for SQLExpress and SQl Server Configuration Manager > SQL Native Client Configuration > Client Protocols

    Restart the services and try again


    Author Comment

    did that already.  named pipes are on.
    LVL 28

    Assisted Solution

    on your local server

    Start --> All Programs --> Microsoft Sql Server 2005 --> Configuration tools --> Sql Server Configuration Manager -->
    Sql Server 2005 Network Configuation --> Protocols for MSSQLSERVER Enable TCP/IP

    Start --> All Programs --> Microsoft Sql Server 2005 --> Configuration tools --> Sql Server Configuration Manager -->
    Sql Server 2005 Network Configuation --> Client Protocols  Enable TCP/IP

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now