djet Posted May 17, 2008 Share Posted May 17, 2008 So I'm trying to connect to an SQL database run by another person and I seem to be failing miserably..... My account is set up to connect and everything with permissions and the host set as wildcards, but when I try to connect i get the "IP @ ISP" is not authorized to connect to there. I was going to try to set it up using SSH, but I'm not sure I want to try to guesswork my way to get it working on his PC. Does anyone here know how to do it or know a good guide for doing it? Link to comment https://www.insanelymac.com/forum/topic/105391-sql-remote-access/ Share on other sites More sharing options...
~pcwiz Posted May 21, 2008 Share Posted May 21, 2008 1) Make sure host name is correct 2) Make sure database name is correct 3) Make sure username and password are correct 4) Make sure that the remote host is set to allow remote connections 5) Make sure that some sort of software or hardware firewall isn't blocking your access attempt (check that on both your computer and the remote computer hosting the database) Link to comment https://www.insanelymac.com/forum/topic/105391-sql-remote-access/#findComment-753556 Share on other sites More sharing options...
djet Posted May 21, 2008 Author Share Posted May 21, 2008 Got it! Somehow the hostard set it up to host on local host, not his IP.... Link to comment https://www.insanelymac.com/forum/topic/105391-sql-remote-access/#findComment-753574 Share on other sites More sharing options...
Recommended Posts