Solved

connecting to a remote sql server 2000 server from public network

Posted on 2008-10-23
2
310 Views
Last Modified: 2013-12-25
Howdy experts....

Quick and hopefully easy question.

I have sql server 2005 installed on a brand new HP notebook running Vista Home Premium 64bit.

I have a sql server 2000 server running behind a firewall with a login page to allow temporary access to the server behind the firewall.

Management studio work fine at home or other similar networks but i notice with this new setup (i had XP and server 2000 before) i cannot seem to connect to the remote server from public networks such as ATTwifi at starbucks.  Im on the road a bit so connecting like this is a great help at times (i dont need it always).  I tried to set the ATTwifi network up as a private network thru vista but it still didnt allow a connection.

is there some other mystery setting i am missing? a default public network setting that is automatically set perhaps??? maybe something about certain public network behavior??   i was able to connect before with XP and server 2000 tools and like i stated above I can connect just fine from home and i have tried it at some other friends home locations.


thanks
rich
0
Comment
Question by:razzzzer
  • 2
2 Comments
 

Author Comment

by:razzzzer
ID: 22790355
FYI... according to the ATT wifi site they do NOT block any ports....
0
 

Accepted Solution

by:
razzzzer earned 0 total points
ID: 22790392
hmmm correction...

Does AT&T Wi-Fi block any specific types of traffic?

Due to the proliferation of viruses, worms and other malicious activity on the Internet, we block specific ports to increase the security of our network. Specifically, TCP traffic is blocked on ports 80 (inbound), 135 (inbound), 137, 138, 139, 445 and 8053. UDP traffic is blocked on ports 1434, 8053, 8083 and 8084. We regularly update our firewalls to address new and pressing security issues.

would the UDP port 1434 be the culprite?
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

707 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

10 Experts available now in Live!

Get 1:1 Help Now