如何从另一台PC访问数据库？ [英] How to access database from another PC?

问题描述

我想发布我的项目。但由于服务器上的版本问题，我无法传输数据。我正在使用2008 R2并且有Sql server 2005.那么在这种情况下我该怎么做。我也试图使用IP地址从另一台计算机访问数据库，但不成功。

I want to publish my project. But i unable to transfer data due to version problem on server. I am using 2008 R2 & There are Sql server 2005. So what can i do in this case. also i am trying to access database from another computer using IP address but it not successful.

推荐答案

会员11221185写道：

Member 11221185 wrote:

我正在使用2008 R2&有Sql server 2005。

I am using 2008 R2 & There are Sql server 2005.

然后你需要改变你的项目才能使用那个版本。

Then you will need to change your project to work with that version.

会员11221185写道：

Member 11221185 wrote:

我试图使用IP地址从另一台计算机访问数据库但是没有成功。

i am trying to access database from another computer using IP address but it not successful.

如果你需要帮助，你需要提供更多的技术细节，我们不能查看您的屏幕，或猜测发生了什么。

You need to provide some more technical detail if you want help, we cannot see your screen, or guess what is happening.

要从LAN / WAN中的SQL Server获取数据，必须启用tcp / ip或命名管道连接。请参阅：

配置服务器以侦听特定TCP端口（SQL Server配置经理） [ ^ ]

配置服务器以在备用管道上侦听（SQL Server配置管理器） [ ^ ]

请注意，有时需要为数据库引擎访问配置Windows防火墙 [ ^ ]

To get data from SQL Server in LAN/WAN, the tcp/ip or named pipes connection must be enabled. See:
Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)[^]
Configure a Server to Listen on an Alternate Pipe (SQL Server Configuration Manager)[^]
Note that sometimes it is needed to Configure a Windows Firewall for Database Engine Access[^]

这篇关于如何从另一台PC访问数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！