471,344 Members | 1,425 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,344 software developers and data experts.

Cannot connect to Local SQL Server

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.
Jul 21 '05 #1
3 1747
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.

Jul 21 '05 #2
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.

Jul 21 '05 #3
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.

Jul 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ronak mishra | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.