From the server access SQL outside your local network, to tell if the outside server can connect to the port. From the command line ->telnet SqlServerHostname 1433 If it connects it will blank screen. Hit ctrl+] to escape; otherwise it will just sit there "Connecting to sqlserverhostname" and eventually time out and return you to the command prompt. On the sql server from the command line issue this command >netstat -an sift through the list and look for this in the second column PublicIP:1433 208.208.208.208:1433 for example, that first column is the ip and ports your server is listening on.
Byron7070
Posts
-
Remote access problem - sql server2008- Out of Domain -
SQL server not startingIf it was working before and isn't working now, I would look to differences. Maybe a windows update or other software installed. Maybe windows update is on automatic and you don't know it. Try rolling any changes back to when things were working. If it never worked, and this is a "fresh" install, go ahead and remove and reinstall. Byron Mann mannb@hostmysite.com byronosity@gmail.com Software Architect hosting.com | hostmysite.com http://www.hostmysite.com/?utm\_source=bb
-
Remote access problem - sql server2008- Out of DomainTwo things I would check are if you have a firewall, if the proper ports are open (1433). Other would be if the sql server is listening on 1433 on a public IP address and internal address. Byron Mann mannb@hostmysite.com byronosity@gmail.com Software Architect hosting.com | hostmysite.com http://www.hostmysite.com/?utm\_source=bb