Cannot find DB on Local Machine in VB.Net RRS feed

  • Question



    I have SQL Server Express 2005. I have it configured for remote connections, but I cannot even see my local dbase. I have the server setup for windows authentication. In VB 2005 database connection wizard I see the db server but on the database itself.


    When I click test connection....without a dbase choosen it says ( i don't have any to choose from).


    "An error has occured while establishing a connection to the server. When connection 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"


    This doesn't make sense because i have changed the the surface area configuration to allow remote connections on both TCP/IP and Named pipes. It shouldn't matter though because this is a local database.






    Sunday, May 13, 2007 6:30 PM


  • Nevermind guys. It was the dang windows firewall. Turned it off and I found it immeditialy.

    sorry, kramer

    Sunday, May 13, 2007 8:12 PM

All replies