Connection with SQL Server Management Express

Discussion in 'Databases' started by heartyb, Jun 27, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. heartyb

    heartyb

    I have tried to connect using the method in the Knowledge base, but I get an error when trying to connect. Here is the error:

    Cannot connect to sql2k503.discountasp.net

    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) (.Net SqlClient Data Provider)

    I have it set up just like the KB, but it will not connect.

    Thanks,

    Hearty B
     
    heartyb, Jun 27, 2006
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    From the error, it seems like your SQL client connection protocol is configured to use Named Pipe instead of TCP/IP. Named Pipe only work within your LAN.

    See http://kb.discountasp.net/article.aspx?id=10381 on how to change the connection protocol.




    Post Edited By Moderator (Joel Thoms) : 6/27/2006 11:14:51 PM GMT
     
    Bruce, Jun 27, 2006
    #2
  3. heartyb

    heartyb

    Changed it to TCP/IP and I am still getting the error. Is there a specific port that it tries to connect to? If this is the case, it could be a firewall issue.
     
    heartyb, Jun 28, 2006
    #3
  4. mjp

    mjp

    mjp, Jun 28, 2006
    #4
  5. heartyb

    heartyb

    Thank you for your help!
     
    heartyb, Jun 29, 2006
    #5
  6. mjp

    mjp

    mjp, Jun 30, 2006
    #6
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page