Solved

cannot connect to the sql server and remote computer

Posted on 2011-02-22
5
362 Views
Last Modified: 2012-05-11
i was able to connect to the sql server and to the remote computer from my laptop at home.Yesterday i uninstalled my anitivirus software and after that i am not able to connect to the sql server as well as to the remote computer.
whenever i try to connect to the sql server i get the error message of sql server

( provider: Named Pipes Provider, error: 40 – could not open a connection to SQL server.
 In the same way i cannot connect to my remote machine.My VPN is working properly
0
Comment
Question by:sqlcurious
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:jmnf
ID: 34953686
Maybe your antivirus had a firewall with sql program/port exception, you may have to create a new program/port exception on your new firewall.
0
 
LVL 15

Accepted Solution

by:
pateljitu earned 300 total points
ID: 34954455
0
 

Author Comment

by:sqlcurious
ID: 34954585
hi jmnf:

how to create program/port exception on your new firewall.
0
 

Author Comment

by:sqlcurious
ID: 34954603
And what could be the problem of not connecting to the remote computer from my laptop.It was working fine other day
0
 
LVL 4

Assisted Solution

by:jmnf
jmnf earned 200 total points
ID: 34955210
To add firewall exception:
For windows Vista/7 you can follow this page instructions:

http://www.worldstart.com/how-to-set-up-windows-firewall-exceptions/

Windows XP is almost exactly, justo go to Control Panel, open Firewall, and follow from step 6 from previous article.

For proxy settings:
Chech the following page:
http://www.freeproxy.ru/en/free_proxy/howuse.htm

You should also check for your network settings.
In Control Panel, open Network Connections, right click on your network connection and click on properties, select TCP/IP 4, click on properties, and make sure the settings are the ones you need... usually automatic... but make sure to write down (or alt+print screen to save ascreenshot of window) before making changes.

And finally check your Internet Connection settings:
Control Panel, Internet Options, Connection, LAN Settings... check Automatically Detect Settigns.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an OSPF network that automatically (dynamically) reroutes network traffic over other connections to prevent network downtime.
Configuring network clients can be a chore, especially if there are a large number of them or a lot of itinerant users.  DHCP dynamically manages this process, much to the relief of users and administrators alike!
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question