CLIENT SERVER APPLICATION REMOTE SERVER ACCESS

Access server within your app? What sort of access?

Client Server Application.

Application is run at client side and access database to remote server.

Thank you.

There are loads of options

-Remoting
-WCF
-Web Services
-TCP/IP
-HTTP
...

Which one is simple to adapt from LAN Application ?

Using IP connection string or something else which is simple ?

Thank you.

Below are the screen shot of the remote server.

Thank you.

Below are the screen shot of the remote server.

Thank you.
REMOTE-SQL-SERVER.PNG

If you are only using .NET clients then WCF should work. Webservices would also do the job.

>Using IP connection string or something else which is simple ?

For you would need to open your SQL Server onto internet which is not desired and most firewalls would block the connection anyway.

What I mean simple is we don't have to change the way we fetch data from LAN SQL server, but just change the connection.

Thank you.

Is this server on LAN or WAN? If WAN then it wont be very simple. As I said, you would be exposing your database server on the internet and your hosting company would probably block the port anyway.

- For you would need to open your SQL Server onto internet which is not desired and most firewalls would block the connection anyway.

Let me try it first. If there is other way the please tell me.

How could do it ?

Thank you.

- Is this server on LAN or WAN? If WAN then it wont be very simple. As I said, you would be exposing your database server on the internet and your hosting company would probably block the port anyway.

It is a web server.
Let's say the company allow us to do it, since it is dedicated web server.

Thank you.

Or let's say it just a company server reside at the company and connected through internet.
The user could use application which reside at client computer from the branch or warehouse somewhere else.

Thank you.

There are usually two options

1) Use tunneling and then the server will be same as if it was on LAN

2) Use one of the options I have previously mentioned.

-1) You can expose the SQL server on web and use it that way but that's not recommended.

Great.

How could I do it using option 1 ?

-1) You can expose the SQL server on web and use it that way but that's not recommended.
We could set the windows server security to accept incoming user  and Ip address. Could we ?

Thank you.

For -1, I do not know the exact details of how to achieve it but I think it will be troublesome

For 1, use VPN. Ask your network administrator.

We don't use VPN just have public/static IP.

Thank you.

Would you please provide good code or link to configuring tcp/ip tunneling through SSH ?

Thank you.

Great.

Thank you very much for your help.