Connecting to SQL Server 2008 over the internet using Management Studio problem
-
I want to connect to my full SQL Server 2008 SP1 on a remote server over the internet using both VS.NET server explorer and MSSQLServer Management, and in both I failed! I tried all the steps described in http://msdn.microsoft.com/en-us/library/ms345343.aspx[^] but I still cannot even telnet the remote server on the ports (1433 or the one I assigned as in the tutorial: 49172) ... BUT I can ping it and it replies. I even closed the firewall application (NOD) on the server as I have full administrative remote desktop access to the server, and still no progress. (And I easily can connect to server using remote desktop) I really need to connect to the server using SQL Server Management. Thank you all
-
I want to connect to my full SQL Server 2008 SP1 on a remote server over the internet using both VS.NET server explorer and MSSQLServer Management, and in both I failed! I tried all the steps described in http://msdn.microsoft.com/en-us/library/ms345343.aspx[^] but I still cannot even telnet the remote server on the ports (1433 or the one I assigned as in the tutorial: 49172) ... BUT I can ping it and it replies. I even closed the firewall application (NOD) on the server as I have full administrative remote desktop access to the server, and still no progress. (And I easily can connect to server using remote desktop) I really need to connect to the server using SQL Server Management. Thank you all
I once did this in the late 90s just to see if it could work, it did. I was then berated for connecting directly to the sql server via the internet for a number of security reasons. That was DECADE ago when the internet was reasonably benign, you need to implement a communcations layer between your SQL server and your client, it is call a WEB SERVICE or WCF. You are then exposing a service to the big bad internet and not your bloody SQL Server.
Never underestimate the power of human stupidity RAH
-
I want to connect to my full SQL Server 2008 SP1 on a remote server over the internet using both VS.NET server explorer and MSSQLServer Management, and in both I failed! I tried all the steps described in http://msdn.microsoft.com/en-us/library/ms345343.aspx[^] but I still cannot even telnet the remote server on the ports (1433 or the one I assigned as in the tutorial: 49172) ... BUT I can ping it and it replies. I even closed the firewall application (NOD) on the server as I have full administrative remote desktop access to the server, and still no progress. (And I easily can connect to server using remote desktop) I really need to connect to the server using SQL Server Management. Thank you all
check is your server configured for remote connections and is it working locally or not and did you mentioned your dynamic port try this with odbc --> client configurations and assign port number to 1433 and check
Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it