Cannot connect to Local SQL Server

  • Thread starter Thread starter Mark Lewis
  • Start date Start date
M

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
(e-mail address removed)

P.S I am using the latest production/old Visual Studio and SQL Server on XP
with all SP applied.
 
Resubmitting this with my new MSDN Alias.

Thanks,

Mark Lewis
(e-mail address removed)
 
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.
 
Resubmitting this with my new MSDN Alias to qualify for support.

Thanks and sorry about the double post,

Mark Lewis
(e-mail address removed)
 
Back
Top