473,385 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 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 1800
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: JW | last post by:
Hi all, I was fine running mysql, and for some reason, after the most recent reboot of my machine, I get the following error and I try the following subsequent commands to try to figure things...
7
by: Joe | last post by:
I have an upload file operation in the web application. UploadForm.asp is the form, and UploadAction.asp is the form processing. //UploadForm.asp <FORM NAME="InputForm"...
1
by: jiing | last post by:
Now let me describe what I have done and my purpose: Originally, I want to user ports to install phpBB But I found that phpBB doesn't support mysql 5.x (but the ports installed mySQL 5.0.0...
8
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- ...
22
by: Smutny30 | last post by:
Hello, I am preparing a database that will store 10 n * GBs - 100 n * GBs of data. I calculated to have 1,2 GB of bufferpools. I run the DB2 v. 8.2.1 alone on 4 GB box. I obtain : ...
2
by: bk | last post by:
This is driving me crazy. I get "SQL Server is unavailable or does not exist" error while developing asp.net application in vs2003's IDE development mode but when I install the application on the...
2
by: zMisc | last post by:
I am using VB.NET 1.1 and cannot connect to a MySQL (v5) database. I've done the following: 1) Create a DSN for MyODBC. 2) Connect using: Driver=MySQL ODBC 3.51 Driver; Server=localhost; Data...
1
by: RashmiKulki | last post by:
hi all, please let me know how access a .aspx file from a remote system,when the client system does not have .NET framework & at the server side the website is running on the ASP.NET web...
1
by: LamSoft | last post by:
I am writing a web portal to modify the users account password. However, it is confusing me... for a few days for this error. It has been work fine while debugging on the development web...
7
by: RN1 | last post by:
Is it possible to connect to my local SQL Server 2005 database from a remote web server? If yes, what ConnectionString do I use? Thanks, Ron
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

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.