• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

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.
0
emi_sastra
Asked:
emi_sastra
  • 12
  • 7
1 Solution
 
CodeCruiserCommented:
Access server within your app? What sort of access?
0
 
emi_sastraAuthor Commented:
Client Server Application.

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

Thank you.
0
 
CodeCruiserCommented:
There are loads of options

-Remoting
-WCF
-Web Services
-TCP/IP
-HTTP
...
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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

Using IP connection string or something else which is simple ?

Thank you.
0
 
emi_sastraAuthor Commented:
Below are the screen shot of the remote server.

Thank you.
0
 
emi_sastraAuthor Commented:
Below are the screen shot of the remote server.

Thank you.
REMOTE-SQL-SERVER.PNG
0
 
CodeCruiserCommented:
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.
0
 
emi_sastraAuthor 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.
0
 
CodeCruiserCommented:
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.
0
 
emi_sastraAuthor 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.
0
 
emi_sastraAuthor 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.
0
 
emi_sastraAuthor 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.
0
 
CodeCruiserCommented:
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.
0
 
emi_sastraAuthor 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.
0
 
CodeCruiserCommented:
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.
0
 
emi_sastraAuthor Commented:
We don't use VPN just have public/static IP.

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

Thank you.
0
 
emi_sastraAuthor Commented:
Great.

Thank you very much for your help.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 12
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now