GPRS access through Sagem router

[NewsreadeR]

You really need to know which port the server is using, then just add that one rule, (You will have to manually create it and then add it)

Then we can go from there.

A quick google says

If I remember correctly, the compact edition uses dynamic ports so it shouldn't be necessary for port 1433/1434 to be open as would be the case for a standard SQL Server/SQL Browser. Additionally, the application itself must have permission to access the database as well. In the non-compact edition, you would achieve this with a service account or a local network service account (or a role) and while enabling permissions on the host side would assure this part, it wouldn't affect the connection state between the application and the database which would be controlled at the sql permission level. It would make sense the compact edition follows the same ruleset as standard SQL Server; I am speculating based on the standard version.

I can ping your IP so the firewall is definitely off, but I would delete all the rules you have added for now to be on the safe side.

[SteveMaguire]

I've changed it back to allow any ip and any port through. I don't want to waste your time so if there isn't anything else you can think of I should go back to the drawing board.

[NewsreadeR]

You ain't wasting my time, I don't mind helping.

The firewall is definitely off as it still pings, so we know the connection is there, its just a case of finding the right port that the software uses I think.

[SteveMaguire]

That's the big question. The manufacturer sent me a picture of how they configure the system on a dlink router. I don't know if this will help but it goes back to NATting

[NewsreadeR]

I just tried it

Your external IP

90.xx.xx.xx/SQLCE35/sqlcesa35.dll

And got this

Microsoft SQL Server Compact Server Agent

So it looks like it is working to a degree, you just need to sort the ports out now I guess.

Will have a look at the piccie now.

[NewsreadeR]

OK not really sure about the picture that they have sent.

The Sky router will not allow a rule with a port of 80255 to be created, I just tried.

The default port for Microsoft SQL Server Compact Edition is 1433 according to Network Topologies (SQL Server Compact Edition) so I would make a new rule for that and then forward it to 192.168.0.2 for now then we can try again?

But you really need to delete all the others that you have added so far to lock your connection down.

[SteveMaguire]

I did point out that it only goes to 65000 odd. I have just created 1433 and added it to 192.168.0.2. That is the only one I now have in

	#	Enable	Service Name	Action	LAN Server IP address	WAN Users	Log
	1		Dotel	ALLOW always	192.168.0.2 (1433:1433)	0.0.0.0 (1:65535)	Never
	Default	Yes	Any	BLOCK always	Any	Any	Never

[NewsreadeR]

Well port 1433 hasn't resolved it. Could you try adding port 255 as well?

We know it works with the firewall disabled so its just a case of finding the right one for now.

Incidentally if you do what you did before, ie add all ports open then you should be able to access it via a neighbour's connection or by 3G I would assume, just to see for yourself.

[SteveMaguire]

OK. Added 255 as well.

What should I be trying to access "http://192.168.0.2/Program Files\Microsoft SQL Server Compact Edition\v3.5\sync\SQL\SQLCE35".

[NewsreadeR]

OK. Added 255 as well.

What should I be trying to access "http://192.168.0.2/Program Files\Microsoft SQL Server Compact Edition\v3.5\sync\SQL\SQLCE35".

If it was going to work behind your router, ie you using it at home, then you could try;

192.168.0.2/SQLCE35/sqlcesa35.dll (but not sure if that would work)

With the rules added to open all the ports, then using mobile or neighbours connection it would be

yourexternalIP/SQLCE35/sqlcesa35.dll (as that is what worked before when I tried it)

But there should be a port number ie

yourexternalIP:1433/SQLCE35/sqlcesa35.dll or yourexternalIP:255/SQLCE35/sqlcesa35.dll

You can get your IP by looking in the router, at present it begins with 2 as an indication for you to see

As I have never used it, I am really not sure how to set it up to listen on a particular port, which is what it seems it is doing, and you need to find what that is,maybe someone else will be able to suggest something?