why i can not connect to a remote sql server ?

Question

hi,

I have two computers on my network, on is my working computer and the other
one is my database server. i want to configure my database server in such a way so that it should be connected from any remote location through its IP.
it is working fine when i connect my database server with my local pc on LAN but when i try to connect to my db server over the internet through its ip adddres it says access denied.. or server is not available....

what configuration/changes do i have to make into my sql server on my db server pc to make it available for connectivity from any where.

Thank you

Answer 1

One thing you have to consider when connecting to your SQL Server remotely from outside of your network is security.  Make sure first that the IP address of your SQL Server box is made public (also, make sure that you completely secured this conection as this is very dangerous).  You can use Terminal Services or Remote Desktop to connect to your SQL Server box.  Another option is to use ASP Enterprise Manager.  You can download a copy at http://www.aspenterprisemanager.com.  This is a web application you can run in your web server which looks exactly like Enterprise Manager running on a browser.

Hope this helps.  If you need help setting up your SQL Server for remote connectivity, lemme know.

Answer 2

I just installed a new SQL server and I'm trying to connect via corpnet and TS. I can terminal in to the box and run SQL but when I tried to access remotely it says remote connections are turned off by default. WHen I try to turn on via TS it says don't have rights how do I get out of this cray loop - do I have to configure locally?

Answer 3

Yes, you will have to use the Configuration Manager tool locally.

Answer 4

Thanks! you saved m a lot of time

Ken