Connecting to SQL 2000 Server from the Internet using public IP Address
-
I have been trying to solve this for quite sometime, I have google it as well. My connection string is as follows: "Data Source=xxx.xxx.8.20,1433;Network Library=DBMSSOCN;Initial Catalog=myDatabase;Trusted_Connection=Yes;" Though my remote server is SQL 2000 Server. On my developer platform I have SQL 2005 and 2000, but whenever I debug the application, it is giving the error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) I can ping the remote server. I can also connect to the server from the studio, please what can I do to solve this problem. Thank you in advance. Thayhor
-
I have been trying to solve this for quite sometime, I have google it as well. My connection string is as follows: "Data Source=xxx.xxx.8.20,1433;Network Library=DBMSSOCN;Initial Catalog=myDatabase;Trusted_Connection=Yes;" Though my remote server is SQL 2000 Server. On my developer platform I have SQL 2005 and 2000, but whenever I debug the application, it is giving the error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) I can ping the remote server. I can also connect to the server from the studio, please what can I do to solve this problem. Thank you in advance. Thayhor
Enable the TCP/IP port. It should have been done at the time of installation of SQL SERVER only. However, follow these steps 1) Start Menu - > Microsoft Sql Server 2005 -> Configuration tools -> Sql Server Configuration Manager 2)Once in that window, expand the SQL Native Client Configuration node which you will find on your left side. 3) From there, choose the Client Protocols. All the client protocols, that are available in your system will be listed in the right pane. 4) Enable the TCP/IP port. 5) Re-Start the SQL SERVER Agent from the services. Hope this helps. :)
Niladri Biswas
-
Enable the TCP/IP port. It should have been done at the time of installation of SQL SERVER only. However, follow these steps 1) Start Menu - > Microsoft Sql Server 2005 -> Configuration tools -> Sql Server Configuration Manager 2)Once in that window, expand the SQL Native Client Configuration node which you will find on your left side. 3) From there, choose the Client Protocols. All the client protocols, that are available in your system will be listed in the right pane. 4) Enable the TCP/IP port. 5) Re-Start the SQL SERVER Agent from the services. Hope this helps. :)
Niladri Biswas
-
Enable the TCP/IP port. It should have been done at the time of installation of SQL SERVER only. However, follow these steps 1) Start Menu - > Microsoft Sql Server 2005 -> Configuration tools -> Sql Server Configuration Manager 2)Once in that window, expand the SQL Native Client Configuration node which you will find on your left side. 3) From there, choose the Client Protocols. All the client protocols, that are available in your system will be listed in the right pane. 4) Enable the TCP/IP port. 5) Re-Start the SQL SERVER Agent from the services. Hope this helps. :)
Niladri Biswas
-
I have been trying to solve this for quite sometime, I have google it as well. My connection string is as follows: "Data Source=xxx.xxx.8.20,1433;Network Library=DBMSSOCN;Initial Catalog=myDatabase;Trusted_Connection=Yes;" Though my remote server is SQL 2000 Server. On my developer platform I have SQL 2005 and 2000, but whenever I debug the application, it is giving the error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) I can ping the remote server. I can also connect to the server from the studio, please what can I do to solve this problem. Thank you in advance. Thayhor
Hello Thayhor, I am also having the same issue. I am trying to build a Window application where i want to connect to a remote sql server 2000 database. Fortunately i have figured out some settings in "Surface Area Manager" of 2005, but no help regarding remote connection in sql server 2000. Please let me know in case you have figured out the solution. Any help is highly awaited. Regards Sujay
-
I cannot telnet to my remote server on port 1433. put I can ping the server. What can I do? Thank you.
modified on Sunday, June 28, 2009 4:34 AM
For some reason I could not post this earlier this day. Check to see if telnet is enabled. On the Vista OS (and WinSrv'08 I believe) telnet is disabled by default unlike XP and WinSrv'03 sp1.
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering
-
I cannot telnet to my remote server on port 1433. put I can ping the server. What can I do? Thank you.
modified on Sunday, June 28, 2009 4:34 AM
Check the following links a) http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_24072150.html[^] b) http://www.sqlservercentral.com/Forums/Topic718583-391-1.aspx[^] hope this helps :)
Niladri Biswas
-
Hello Thayhor, I am also having the same issue. I am trying to build a Window application where i want to connect to a remote sql server 2000 database. Fortunately i have figured out some settings in "Surface Area Manager" of 2005, but no help regarding remote connection in sql server 2000. Please let me know in case you have figured out the solution. Any help is highly awaited. Regards Sujay
Hi Sujay, The default port on which SQL SERVER 2005 is running is I guess 1433. If that is supposed to be the case, then on the same port SQL SERVER 2k cannot run. Change the port, give Server name as [INSTANCE NAME,PORT NUMBER] and try again. Also check the bandwidth of the connection, since data storage and retrieval might take a lot of time At the same time check if the firewall is open or not! :)
Niladri Biswas
-
Hi Sujay, The default port on which SQL SERVER 2005 is running is I guess 1433. If that is supposed to be the case, then on the same port SQL SERVER 2k cannot run. Change the port, give Server name as [INSTANCE NAME,PORT NUMBER] and try again. Also check the bandwidth of the connection, since data storage and retrieval might take a lot of time At the same time check if the firewall is open or not! :)
Niladri Biswas
Hello Niladri, Thanks for the quick response. Well actually i am new in developing and not having that much sense. I was wondering if you could please provide me with some detailed step by step configuration of sql server. As far as ports are concerned i think we can put it in between 1433-1444 and i have given it 1438. but still i am stuck with two errors: A dialog box (Not from VS 2005 that's for sure) appears with the following error - Invalid Parameter and then asking to enable JIT in my machine.config file to debug the issue Similarly another dialog box occurs this time with the error msg as Object reference not set to the instance of object. and i am sure this is also not comming from vs 2005 because i have put my code in try.... catch and have a different messagebox to display the exception.
....
Using System.Data.SqlClient;
....
....
SqlConnection oSQLConn = new SqlConnection();
.....
oSQLConn.ConnectionString = "Network Library=DBMSSOCN; Data Source=xxx.xxx.xxx.xxx,1438;Initial Catalog=databaseName;User ID=myUsername;Password=myPassword"Please guide me further in the issue Regards Sujay