Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

connecting to a remote sql server 2000 server from public network

Posted on 2008-10-23
2
Medium Priority
?
327 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

704 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