如何在同一网络上使用另一台PC上的SQL Server? [英] How do you use SQL Server from another PC on the same network?
问题描述
我有一台连接了两台PC的家庭网络。一台PC安装了SQL Server,还有一个Excel电子表格,用于从SQL Server中的数据库表中读取数据。 excel电子表格位于共享文件夹中,因此其他PC可以打开和编辑该文件,但无法刷新从sql server数据库表中检索到的数据。我不断收到一条错误消息,指出服务器不存在。我无法以访客身份登录。
无论如何,我可以使用网络上的excel文件并从任何电脑上刷新sql server中的数据网络?
I have a home network with two PCs connected. The one pc has SQL Server installed and also an Excel spreadsheet that reads data from a database table in SQL server. The excel spreadsheet is in a shared folder so the other PC can open and edit the file, but can not refresh the data retrieved from the sql server database table. I keep getting an error message that says the server does not exist. And i can't login as a guest.
Is there anyway i can use the excel file on the network and refresh the data from the sql server from any pc on the network?
推荐答案
1)在SQL Server上启用网络(默认为关闭)请参阅: http://technet.microsoft.com/en-us/library/hh231672.aspx [ ^ ]
2)配置防火墙您的SQL Server机器允许SQL Server
3)在家庭网络上通过IP地址连接而不是名称(在运行中输入IPCONFIG以查看您的SQL服务器IP)是 - 通常像192.168.xx)。
1) Enable networking on your SQL Server (default is off) see : http://technet.microsoft.com/en-us/library/hh231672.aspx[^]
2) Configure the firewall on your SQL Server machine to allow SQL Server
3) On a home network connect via IP address instead of names (type IPCONFIG in your run to see what your SQL server IP is - usually like 192.168.x.x ).
转到 http://csharp-sqlconnection.blogspot .com / [ ^ ]方便和最短的数据库连接方式
go to http://csharp-sqlconnection.blogspot.com/[^] for easy and shortest way for database connectivity
这篇关于如何在同一网络上使用另一台PC上的SQL Server?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!