Cannot connect to Local SQL Server

[Mark Lewis]

I am having trouble connecting to my local sql server from either the Server
Explorer or vb.net code. The problem is connected to the Norton Internet
Security 2005 Firewall as when I disable Norton everything works and if
Norton is enabled but the PC is not plugged into the network it also works.

When I am connected to the network the Firewall does pop up asking whether
or not I want to allow my vb.net program to access a DNS. I have tried using
localhost, the hardcoded IP of my machine, and my machine name (the usual
method) without any success. It is as if Visual Studio always tries to
resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
Enterprise Manager all work fine at the same time Visual Studio/VB.Net does
not.

Any ideas?

Thanks,

Mark Lewis
md*****@mdlewis.com

P.S I am using the latest production/old Visual Studio and SQL Server on XP
with all SP applied.

[Nick Malik [Microsoft]]

here's an idea: configure the Norton product so that your machine can access
DNS.

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"Mark Lewis" <md*****@mdlewis.com> wrote in message
news:u$**************@TK2MSFTNGP10.phx.gbl...

I am having trouble connecting to my local sql server from either the
Server Explorer or vb.net code. The problem is connected to the Norton
Internet Security 2005 Firewall as when I disable Norton everything works
and if Norton is enabled but the PC is not plugged into the network it also
works.

When I am connected to the network the Firewall does pop up asking whether
or not I want to allow my vb.net program to access a DNS. I have tried
using localhost, the hardcoded IP of my machine, and my machine name (the
usual method) without any success. It is as if Visual Studio always tries
to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
Enterprise Manager all work fine at the same time Visual Studio/VB.Net
does not.

Any ideas?

Thanks,

Mark Lewis
md*****@mdlewis.com

P.S I am using the latest production/old Visual Studio and SQL Server on
XP with all SP applied.

[Mark Lewis]

Resubmitting this with my new MSDN Alias.

Thanks,

Mark Lewis
md*****@mdlewis.com
"Mark Lewis" <md*****@mdlewis.com> wrote in message
news:u$**************@TK2MSFTNGP10.phx.gbl...

I am having trouble connecting to my local sql server from either the
Server Explorer or vb.net code. The problem is connected to the Norton
Internet Security 2005 Firewall as when I disable Norton everything works
and if Norton is enabled but the PC is not plugged into the network it also
works.

When I am connected to the network the Firewall does pop up asking whether
or not I want to allow my vb.net program to access a DNS. I have tried
using localhost, the hardcoded IP of my machine, and my machine name (the
usual method) without any success. It is as if Visual Studio always tries
to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
Enterprise Manager all work fine at the same time Visual Studio/VB.Net
does not.

Any ideas?

Thanks,

Mark Lewis
md*****@mdlewis.com

P.S I am using the latest production/old Visual Studio and SQL Server on
XP with all SP applied.

[Mark Lewis]

Resubmitting this with my new MSDN Alias to qualify for support.

Thanks and sorry about the double post,

Mark Lewis
md*****@mdlewis.com
"Mark Lewis" <md*****@mdlewis.com> wrote in message
news:u$**************@TK2MSFTNGP10.phx.gbl...

I am having trouble connecting to my local sql server from either the
Server Explorer or vb.net code. The problem is connected to the Norton
Internet Security 2005 Firewall as when I disable Norton everything works
and if Norton is enabled but the PC is not plugged into the network it also
works.

When I am connected to the network the Firewall does pop up asking whether
or not I want to allow my vb.net program to access a DNS. I have tried
using localhost, the hardcoded IP of my machine, and my machine name (the
usual method) without any success. It is as if Visual Studio always tries
to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
Enterprise Manager all work fine at the same time Visual Studio/VB.Net
does not.

Any ideas?

Thanks,

Mark Lewis
md*****@mdlewis.com

P.S I am using the latest production/old Visual Studio and SQL Server on
XP with all SP applied.