Solved

connecting to a remote sql server 2000 server from public network

Posted on 2008-10-23
2
320 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

Suggested Solutions

Title # Comments Views Activity
Internet Protocol Security question 3 96
Sql Server group by 10 45
Multiple MPLS Circuits Connecting to LAN 3 47
Sonicwall one way trust 2 43
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
Most of the applications these days are on Cloud. Cloud is ubiquitous with many service providers in the market. Since it has many benefits such as cost reduction, software updates, remote access, disaster recovery and much more.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
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…

820 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