Error connecting VWD to database

Discussion in 'Databases' started by CARMCK, Jul 24, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I am trying to follow KB 10413, to configure members and roles in my database.

    I created a new VWD application and changed connectionstrings in web.config. I successfully opened ASP.NET configuration tool, then the Security tab threw the error below.

    I don't know where to start looking for a solution...

    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)

    I also mentioned this problem in another thread at:
    http://community.discountasp.net/default.aspx?f=16&m=12001#m12150

    but I don't know if this problem is the same as the one in that thread.

    thanks for any help
    ck

    July 23:

    Maybe I should have asked this first:

    Since the error message clearly says SQL Server does not allow remote connections, is it POSSIBLE to remotely connect to the discountasp.net server with VWD?

    ck






    Post Edited (CARMCK) : 7/24/2006 5:36:33 PM GMT
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    TheSQL client connection protocol on your computer is probably set to NamedPipe.


    Couple things you can do


    1) Try update your client connection protocol to TCP/IP. See http://kb.discountasp.net/article.aspx?id=10385


    OR


    2) put tcp: in front of your connection string. For example, if your database is hosted on sql2k501, you would always use tcp:sql2k501.discountasp.net rather than sql2k501.discountasp.net

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. It works. Thank you so much.

    ck[​IMG] [​IMG] [​IMG]
     
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