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

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.