Sunday, February 12, 2012

Cannot find DB on Local Machine in VB.Net

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.

Thanks

Kramer

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

sorry, kramer

|||

I am facing the same problem.

Can you please help me?

thanks,

With regards,

Girish.

kramer9802 wrote:

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

sorry, kramer

|||

hi Girish,

try having a look at http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx..

regards

No comments:

Post a Comment