数据库访问在两个区域 [英] Database Accessing in two area

问题描述

我正在向一家公司开发软件。该软件是多系统访问软件。我在其LAN网络中的服务器系统中托管数据库。现在公司从旧建筑开始其他分支1公里的那天..他们对我说他们想要在新分支中使用相同的数据库..是否可以从那里访问相同的数据库？没有有线连接之间有两个分支..如果可以从那里连接同一个服务器？

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?

推荐答案

是的...但是如果你能做到这一点并不是一个好习惯避免它。

您需要做的是打开服务器到远程连接（因此它可以在互联网上公开）并通过IP地址从那里连接。我们无法准确告诉您如何执行此操作，因为它主要是网络配置问题，我们不了解您的环境。谷歌应该可以给你一些起点。



但是......这是一件危险的事情，因为任何人都可以访问服务器 - 所以你需要确保你把它牢牢锁住 - 开始摆脱sa用户并确保所有用户都有强密码和尽可能有限的访问权限。





如果你可以避免 - 做。



错别字[/ edit]

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]

这篇关于数据库访问在两个区域的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！