connecting to a remote sql server 2000 server from public network
Posted on 2008-10-23
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.