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.
LVL 1
emi_sastraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
emi_sastraAuthor Commented:
Great.

Thank you very much for your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.