How to share a SQL DataBase over the internet

[Jack_Sparrow]

​

According above figure
how to share a DB in a server over the internet
and allow to a remote PC to connect using the static IP given by ISP (220.223.169.12) using a connection string...

 

[Jack_Sparrow]

bump...

 

[vidura99]

You just need to know the ip address of the sql server to connect to and the authentication details for that server. Use a connection string like the following.But not sure machan

"Provider=SQLOLEDB;Data Source=some_ipaddress;UID=some_user_name;PWD=_some_password;DATABASE=some_database_name"

 

[Jack_Sparrow]

You just need to know the ip address of the sql server to connect to and the authentication details for that server. Use a connection string like the following.But not sure machan

"Provider=SQLOLEDB;Data Source=some_ipaddress;UID=some_user_name;PWD=_some_password;DATABASE=some_database_name"

when DB is hosted in the server, server/ip (192.168.2.1) can be used to get connected within the local network, this can be done the con string yu mentioned....

but when it comes to internet, ISP static IP address directly connected to the ADSL router... all i want is to use ISP IP add and connect to the DB resides on server...

So i think some configuration has to be done at router.. ip forwading or something like that

 

[vidura99]

when DB is hosted in the server, server/ip (192.168.2.1) can be used to get connected within the local network, this can be done the con string yu mentioned....

but when it comes to internet, ISP static IP address directly connected to the ADSL router... all i want is to use ISP IP add and connect to the DB resides on server...

So i think some configuration has to be done at router.. ip forwading or something like that

Machan. That private IP to public IP translation done via the NAT (Network address translation) at the router. For this purpose you have to have a advanced router like CISCO

 

[EHDEHD]

wla

 

[eshan1]

try this http://dyn.com/
I have hosted a web service in my local PC using this works fine over the internet. I think it's possible to do what u r asking using dyn.

 

[Jack_Sparrow]

Machan. That private IP to public IP translation done via the NAT (Network address translation) at the router. For this purpose you have to have a advanced router like CISCO

ehema netuwa berida nikan router ekakin mala magulai wenne
den etakota IIS server ekak host karannat CISCO router onida?

 

[vidura99]

Ubata static IP ekakwath thiyenawada?

 

[Jack_Sparrow]

Ubata static IP ekakwath thiyenawada?

ya tiyanawa.. mama SLT lagen gatta static ip ekak

 

[Jack_Sparrow]

try this http://dyn.com/
I have hosted a web service in my local PC using this works fine over the internet. I think it's possible to do what u r asking using dyn.

thanks dude... ill check dat one

 

[kosandpol]

​

According above figure
how to share a DB in a server over the internet
and allow to a remote PC to connect using the static IP given by ISP (220.223.169.12) using a connection string...

1. On the SQL server, enable SQL authentication and set a password for the sa account (if the password is empty) and set a username & password for the required database.

2. On the SQL server, set it to listen on TCP/IP on port 1433

3. On the windows server, open port 1433 for incoming connections.

4. on the Router, set up port forwarding and forward TCP port 1433 to 192.168.2.1 on port 1433

after this, you can access the SQL server using the router IP (202.223.169.12 ) using the sql user name and password.

 

[sameerasadaru]

bumpz

 

[Jack_Sparrow]

1. On the SQL server, enable SQL authentication and set a password for the sa account (if the password is empty) and set a username & password for the required database.

2. On the SQL server, set it to listen on TCP/IP on port 1433

3. On the windows server, open port 1433 for incoming connections.

4. on the Router, set up port forwarding and forward TCP port 1433 to 192.168.2.1 on port 1433

after this, you can access the SQL server using the router IP (202.223.169.12 ) using the sql user name and password.

thanks a lot buwa
in router for local or remote 192.168.2.1 on port 1433 should has to be step up?

 

[Jack_Sparrow]

bumpz

thanks machan

 

[kosandpol]

thanks a lot buwa
in router for local or remote 192.168.2.1 on port 1433 should has to be step up?

Protocol : TCP/IP
Local IP : 192.168.2.1
Local Port : 1433 - 1433
Public Port : 1433 -1433
Interface : PPPoE

 

[Jack_Sparrow]

Protocol : TCP/IP
Local IP : 192.168.2.1
Local Port : 1433 - 1433
Public Port : 1433 -1433
Interface : PPPoE

ela ela thanks machan
for interface PPPoE is not available in the list
ppp0-ppp7 are only available

 

[vidura99]

Protocol : TCP/IP
Local IP : 192.168.2.1
Local Port : 1433 - 1433
Public Port : 1433 -1433
Interface : PPPoE

amma gahai. maru trick ekak ne. port forwarding walin puluwan nennam

 

[kosandpol]

ela ela thanks machan
for interface PPPoE is not available in the list
ppp0-ppp7 are only available

then select that one. It just needs to be the PPP connection that the router makes with the SLT servers.

 

[Jack_Sparrow]

amma gahai. maru trick ekak ne. port forwarding walin puluwan nennam

eka tamai matat ona une