open up 1433 TCP and then you should be able to connect to your db remotely via Sql enterprise manager & Query analyzer as long as you have remote connections allowed in the server setup.
----- Original Message ----- From: "Matthew Small" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Wednesday, July 02, 2003 10:31 AM Subject: Connecting to remote SQL2K server with Query Analyzer > Matthew Small > IT Director > Showstopper American Dance Championships > [EMAIL PROTECTED] > 843-357-1847 > Hi - > I have a remote SQL2K server on which I forgot to add VNC, and > right now I'm in a remote location. I need to have access to my server > through Query Qnalyzer, but I don't know the process of connecting to my > server like this. I have remote control of the firewall, and can open > ports up as needed, and I have the IP of the server. Can anybody help? > > Thanks, > Matthew Small > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
