如何从另一台计算机连接到 SQL Server? [英] How to connect to SQL Server from another computer?

问题描述

我想从家里使用 SQL Server 2005 连接到另一台 PC.

I want to connect from home using SQL Server 2005 to another PC.

我查看了 msd...但在连接之前它说我应该连接到另一台计算机使用计算机管理并没有成功....我只能从我的工作组连接到计算机?

I had a look on the msd...but before connecting it says I should connect to another computer using the computer management and it didn't work out....I can only connect to computers from my workgroup?

谢谢，路易莎

推荐答案

如果你想远程连接到 SQL Server，你需要使用一个软件——比如 Sql Server Management studio.

If you want to connect to SQL server remotly you need to use a software - like Sql Server Management studio.

计算机不需要在同一网络上 - 但它们必须能够使用诸如 tcp/ip 之类的通信协议相互连接，并且服务器必须设置为支持您选择的类型的传入连接.

The computers doesn't need to be on the same network - but they must be able to connect each other using a communication protocol like tcp/ip, and the server must be set up to support incoming connection of the type you choose.

如果您想连接到另一台计算机(浏览文件?)，您可以使用其他工具，而不是 sql server(您可以映射驱动器并通过那里访问它...)

if you want to connect to another computer (to browse files ?) you use other tools, and not sql server (you can map a drive and access it through there ect...)

要使用 tcp/ip 启用 SQL 连接，请阅读这篇文章:

To Enable SQL connection using tcp/ip read this article:

对于 Sql Express:快递对于 Sql 2008:2008

For Sql Express: express For Sql 2008: 2008

确保您也通过机器防火墙启用访问.

Make sure you enable access through the machine firewall as well.

您可能需要在用于连接服务器的计算机上安装 SSMS 或 Toad.两者都可以从他们的公司网站下载.

You might need to install either SSMS or Toad on the machine your using to connect to the server. both you can download from their's company web site.

这篇关于如何从另一台计算机连接到 SQL Server?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！