PLEASE HELP ME!!!!!! PLEASE!!!!!!

Anon

Hi. I'm going a bit mad because of this. In my job, we need to connect a computer running an SQL server. But the problem is that this computer is on an intranet AWAY from our own intranet.

So the idea is to get into that intranet (managed by an ADSL router), find the machine running the SQL server and stablish the connection.

I don't know if it's me who has to change the scripts for this to work or if it's the people running the ADSL who have to configure it to make it possible for me to enter that intranet.

I tried the IP, the IP with the 1433 as port and i just don't get anything.

Any, i repeat ANY help is very much wanted.

Thanks in advance.

Alex

Anon

I supose that your server is MySQL (see the port you are trying).
First, check if the server's IP is visible from outsite.
(ping IP)
If it works, watch the rights for the mysql user using for connect in the mysql database... table db, user etc ... and set the proprer rights to allow connections from any host. (%)
Chris

Alex wrote:

Hi. I'm going a bit mad because of this. In my job, we need to connect a computer running an SQL server. But the problem is that this computer is on an intranet AWAY from our own intranet.

So the idea is to get into that intranet (managed by an ADSL router), find the machine running the SQL server and stablish the connection.

I don't know if it's me who has to change the scripts for this to work or if it's the people running the ADSL who have to configure it to make it possible for me to enter that intranet.

I tried the IP, the IP with the 1433 as port and i just don't get anything.

Any, i repeat ANY help is very much wanted.

Thanks in advance.

Alex

Anon

MMM. Well... The database is a Microsoft SQL SERVER 2000. It's located on an intranet. And the IP all computers in that intranet have when they go to internet is the same, that of the ADSL router. So, no problem connecting that IP. But, how shall i locate the computer having the SQL SERVER instance among all of them?

That is my problem. How to code that. Besides, i'm using ODBC functions to connect. I do this because mssql_* functions don't really work very well, especially on ntext fields. 🙂

Well, that's my question. How to locate that computer in that 50 computers intranet.

Thanks in advance.

Alex

Anon

Now I see.
The problem it's more complicated.
You must write a rule on the computer which have the real IP, to forward the MSSQL port to the computer from the intranet where runs the SQL Server, maintaining the same port.

Take a look at: http://www.linuxvirtualserver.org/VS-NAT.html

Chris