Database Accessing in two area

Question

0.00/5 (No votes)

See more:

I am developing a software to a company in earlier.. The software is multi system accessing software.. I am hosting database in a server system in their LAN network. Now the day that company start other branch 1 Kilometer from old building.. They said to me they want same database in the new branch.. Is it possible to access same database from there? There two branches between No wired connection.. if its possible to connect the same server from there?

Posted 15-Sep-14 22:51pm

Member 11011845

Add a Solution

Comments

Gihan Liyanage 16-Sep-14 5:02am

Don't you have LAN integrated to the new branch of your company ?

Member 11011845 16-Sep-14 6:12am

yes there is another LAN network

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-09-15T23:03:00

Yes...but it's not a good practice if you can avoid it.
What you need to do is open the Server to remote connections (so it is publicly available on the internet) and connect from there via the IP address. We can't tell you exactly how to do this as it's mostly a network config issue, and we have no idea about your environment. Google should be able to give you some starter points though.

But... this is a dangerous thing to do as anyone can access the server - so you need to make sure you have it locked down nice and tight - start by getting rid of the "sa" user and making sure all users have strong passwords and as limited access as possible).

If you can avoid it - do.

[edit]Typos[/edit]