允许sql server 2008 r2端口跨公共IP [英] Allow sql server 2008 r2 port cross public IP

问题描述

大家好



我是一名软件开发人员。我使用C＃.net和microsoft sql server 2008r2。

现在我有一个问题，微软sql server 2008 r2无法从任何地方连接到互联网。

我有一个公共IP和公共IP在tp-link路由器中配置。

和我的数据库存储在一台连接到路由器的计算机上，这台计算机也可以使用互联网。

In路由器我使用转发IP到这台电脑，我已经将静态IP设置到这台电脑了。



所以问题是我无法在这台电脑上连接这个数据库通过互联网。

i google很多次但仍然没有解决方案。



请帮助我！



谢谢

Hi All

I am a software developer. I work with C#.net and microsoft sql server 2008r2.
Now i have a problem with microsoft sql server 2008 r2 can not connect from anywhere has internet.
I have a public IP and public IP configure in tp-link router.
and my database store in a computer which connect to the router and this computer can also use internet too.
In the router I use forward IP to this computer and i have set the static IP to this computer already.

So the problem is I can not connect this database in this computer over the internet.
i google much times but still have no the solutins.

Please help me!

Thanks

推荐答案

如果您使用的是Windows 7或更高版本，则需要允许sql server通过防火墙。安装时默认阻止大多数程序。要允许数据库引擎服务，请配置Windows防火墙以进行数据库访问

If you're using Windows 7 or later, you need to allow sql server through the firewall. Most programs are blocked by default on installation. To allow the database engine services, configure windows firewall for database access

这篇关于允许sql server 2008 r2端口跨公共IP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！