Solved

cannot connect to the sql server and remote computer

Posted on 2011-02-22
5
360 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
  • 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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Article by: rfc1180
The Maximum Segment size (MSS) is an important consideration when troubleshooting connectivity via the Internet/Intranet. As the packets are routed via the Internet/Intranet, the packets must traverse through multiple routers in the path between two…
Creating an OSPF network that automatically (dynamically) reroutes network traffic over other connections to prevent network downtime.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

770 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