Maxis 3G Connection

I cannot connect to SQL Server 2000(Remote Server) through Maxis 3G connection. The remote server does not has firewall.

I'm using Windows Application to connect to SQL Server 2000.

dim strsqlcon as string = "Server=000.000.000.000;databse=dbname;usr=sa;pws=1234"

dim sqlcon as sqlconnection = new sqlconnection(strsqlcon)

sqlcon.open()

"It's Error : Sql not exist or access denied."

But I can connect to SQL Server 2000(Remote Server) through Local Area Connection.

Have any solution?

Thank you.

try to ping the server.|||

I can ping the server through 3G Connection.

Result :

"Reply from xxx.xxx.xxx.xxx: bytes=32 time=369ms++ TTL=115"

|||

Can you telnet to your SQL Server? [YES | NO, please specify the error message ]

In cmd.exe console, type “telnet <server name> port, where port can be 135, 445 or sql_server_tcp_port. If your cmd.exe console turns into a complete black screen with a cursor flushing on top left corner, you are connected. Type ctrl+’[‘ to bring up telnet prompt and type “quit” <enter>.

|||

I enabled telnet service in Services Tool.

In cmd, i type "telnet xxx.xxx.xxx.xxx:1433"

Error " Connecting To xxx.xxx.xxx.xxx:1433...Could not open connection to the host, on port 23: Connect failed"

|||

run the profiler.

check to see if your connection is connecting to sql server

if there's nothing in the profiler you are not connecting

if you are connecting to sql server but encountering permission problem

you should see it there

|||

Type "telnet xxx.xxx.xxx.xxx 1433", instead of "telnet xxx.xxx.xxx.xxx:1433". No ":" in front of the port 1433.

Please also try "telnet xxx.xxx.xxx.xxx 135".

Please also try "telnet xxx.xxx.xxx.xxx 445".

If non of them can connect you, it is the network that block you from being able to connect.

|||

Its show error:

"Connecting To x.x.x.x ...Could not open connection to the host, on port 1433: Connect failed."

How do i open the port?

What should i do?

|||Server didn't install network firewall.

If telnet 1433 port through our normally connection on pc, its fine. Only 3G connection cannot telnet 1433 port but can telnet 80 port, 9119 port.

Is it SQL Server Network Utility or Client Network Utility to do setting for 3G connection?

|||

Mostlikely, your 3G network provider might selectively block the port, you can either find a port that the 3G network dosn't block, and make the SQL Server listening on that port, using SQL Server Configuration Manager, or you can ask your network provider to unblock the port. Either way, exposed your SQL Server directly to the public network is not a good idea in practice from security perspectie.

Good Luck.

|||

Normally, network connection can access 1433 port and 3G network still cannot access.

How to configure Server Network Utility or Client Network Utility in SQL Server 2000?

sql