Solved

cannot connect to the sql server and remote computer

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Network ports are the threads that hold network communication together. They are an essential part of networking that can be easily ignore or misunderstood, my goals is to show those who don't have a strong network foundation how network ports opera…
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!
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

839 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