Link to home
Create AccountLog in
Avatar of emi_sastra
emi_sastra

asked on

CLIENT SERVER APPLICATION REMOTE SERVER ACCESS

Hi All,

I create a windows app. I want to access server from client computer.
The server is also serve as web server.

How could I do it ?

Thank you.
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Access server within your app? What sort of access?
Avatar of emi_sastra
emi_sastra

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Great.

Thank you very much for your help.