Maxis 3G connection

I cannot connect to SQL Server 2000(Remote Server) through Maxis 3G connection.

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.

Hello,

I have no idea what "Maxis 3G Connection" is, but I assume it's what one of your network connections is called. The host 000.000.000.000 is invalid - you must specify either an IP or hostname of a valid SQL Server host.

What exactly is it that you're trying to connect to?

Cheers,

Rob

|||

000.000.000.000 is example ipaddress. =>203.164.125.956

Maxis is mobile gateway from Malaysia.(http://www.maxis.com.my/3g/main.asp)

I want connect to SQL Server 2000(Remote Server) through 3G connection from my laptop. But its show me error :"Sql Server is not exist or access denied.

|||Sound like a case of firewall problem. Since you're trying to connect to a default instance, be sure tcp port 1433 is open.

http://support.microsoft.com/kb/287932|||

Server does not has any firewall.

I can connect to SQL Server 2000 through Lan Area Connection.

Is it 3G Connection TCP different with Lan Area Connection TCP?

|||The firewall mentioned here is the network/ISP firewall. You need to check with your network adminstrator to make the port is open.|||

The Port is open if not, i cannot connect through Lan Area Connection.

Windows Application(VB.Net) + SQL Server 2000

now, i cannot connect through 3G connection in my laptop.

|||

I can ping the server through 3G Connection.

Result :

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

|||

LAN connection is not the same as WAN connection. For a WAN user to connect to an internal LAN, it has to go through a firewall - imagine if there isn't a firewall. Every one out in the internet can get to your internal LAN.

Can you telnet to your server on port 1433?

|||

I didnt install any firewall on my Server.

If firewall is blocking, how do i set it off?

|||As I mentioned in earlier post, you need to contact your network administrator to open the port on the network firewall/router.

Basically, you have to get through the network firewall/router before you can get to the server.|||

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"

|||You want to telnet from your laptop to the server as:

telnet x.x.x.x 1433

There is a space between the server IP and TCP port.

If it's successful, you should see the laptop IP on the server's netstat output.

netstat -n|||

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?

|||You need to talk to you network administrator for your company and ask him/her to open the port on the network firewall.