如何在另一台客户端计算机的ODBC中配置远程计算机的SQL Server DSN名称? [英] How to configure a remote machine's SQL server DSN name in another client machine's ODBC?

问题描述

我在主机上有一个SQL Server，它运行良好.

我想共享SQL服务器，以便局域网(不是Internet)中的所有其他计算机都可以访问它，以便我可以在所有其他客户端计算机的ODBC中配置服务器(即控制面板\所有控制面板项目\管理"工具\数据源(ODBC).lnk \)

I have a SQL server in a host machine and it is running fine.

I want to share the SQL server such that it is accessible by all other machines in LAN (Not Internet) and so that i can configure the server in all other client machine''s ODBC (i.e. Control Panel\All Control Panel Items\Administrative Tools\Data Sources (ODBC).lnk\)

Can you please help me by explaining in detail?

推荐答案

^ ]可能会有所帮助.

This[^] might help.

您是说要配置服务器端?基本上，SQL Server可以随时进行连接，因此您只需要确保以下几点:
-协议等，请为此使用配置管理器: http://technet.microsoft.com/en-us/library/ms174212.aspx [ ^ ]
-登录名和用户: http://msdn.microsoft.com/en-us/library/aa337562.aspx [^ ]
-如果服务器和另一台计算机之间有防火墙，则可能必须打开sql服务器的端口.

还有很多其他配置，但是希望这可以帮助您入门.

You mean you want to configure the server side? Basically the SQL Server can take connections at any time so you just have to ensure few things:
- protocols etc, use configuration manager for that: http://technet.microsoft.com/en-us/library/ms174212.aspx[^]
- logins and users: http://msdn.microsoft.com/en-us/library/aa337562.aspx[^]
- and possibly you have to open a port for sql server if you have a firewall between the server and the other machine.

There are lots of other configuration things also but hopefully this gets you started.

这篇关于如何在另一台客户端计算机的ODBC中配置远程计算机的SQL Server DSN名称?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！