We help IT Professionals succeed at work.

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.
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Access server within your app? What sort of access?

Author

Commented:
Client Server Application.

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

Thank you.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
There are loads of options

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

Author

Commented:
Which one is simple to adapt from LAN Application ?

Using IP connection string or something else which is simple ?

Thank you.

Author

Commented:
Below are the screen shot of the remote server.

Thank you.

Author

Commented:
Below are the screen shot of the remote server.

Thank you.
REMOTE-SQL-SERVER.PNG
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
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.

Author

Commented:
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.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
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.

Author

Commented:
- 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.

Author

Commented:
- 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.

Author

Commented:
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.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
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.

Author

Commented:
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.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
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.

Author

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

Thank you.

Author

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

Thank you.
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:

Author

Commented:
Great.

Thank you very much for your help.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.