473,657 Members | 2,593 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1814
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*****@mdlewi s.com> wrote in message
news:u$******** ******@TK2MSFTN GP10.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*****@mdlewi s.com> wrote in message
news:u$******** ******@TK2MSFTN GP10.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*****@mdlewi s.com> wrote in message
news:u$******** ******@TK2MSFTN GP10.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
3885
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 out: # mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) # mysqld_safe
7
4531
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" ACTION="UploadAction.asp" METHOD="POST" enctype=multipart/form-data> <input type="file" name="fileName"> //etc ... </FORM>
1
121524
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 alpha) so I deinstall mysql5-server and mysql5-client And then I install mysql41-server and mysql41-client on FreeBSD 5.3 by ports but now , mysql is not workable
8
5462
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 -------------------------------------------------------------------------------- Hello, I have a very simple problem but cannot seem to figure it out. I have a very simple php script that sends a test email to myself. When I debug it in PHP designer, it works with no problems, I get the test email. If
22
5576
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 : "SQL1478W The defined buffer pools could not be started. Instead, one small
2
1539
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 server the error disappears and everthing seems to be ok. The error does not appear when I connect to the same databse on the local sql2000 server. I use the same connection string for local WindowsXP+sql2000 server and the remote Windows 2003...
2
10498
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 Source=test; UID=test; PWD=pwd; OPTION=3 When I run my app, I get this error: An OLE DB Provider was not specified in
1
1912
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 development server. Error 1:Also i get a error saying that this application is beyond IIS application level even though i am using ASP.NET web development server& also talks about virtual directory of IIS not of ASP.NET web development server when i...
1
7533
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 server, however when i run on the on the IIS (on same computer), it has this error: A specified logon session does not exist. It may already have been terminated. But if I connect the local computer by supplying the admin username and password, it has...
7
5931
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
8385
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8723
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8602
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7316
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4150
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1941
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1601
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.