Solved

connecting to a remote sql server 2000 server from public network

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
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…

932 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

11 Experts available now in Live!

Get 1:1 Help Now