Solved

connecting to a remote sql server 2000 server from public network

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
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…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

630 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