Solved

cannot connect to the sql server and remote computer

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to convert to a different Class of IP addresses 35 90
Firewall issues 6 90
Wireshark trace help 10 38
Firewall attack 16 150
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…
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!
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now