Don't forget to setup the SQL server in the Client Network Utility. If you don't, it will never connect. I see many people forgot this part.
Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -----Original Message----- From: William Wheatley [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 10:42 AM To: CF-Community Subject: Re: Connecting to remote SQL2K server with Query Analyzer 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
