我遗漏了一些基本的东西 [英] I'm missing something basic

问题描述

Hello Everyone：

我仍​​然无法访问存储在MRM-DT-002上的数据库。系统崩溃了，所以在我恢复之后我安装了MS SQL Server 2008 Standard并安装了Northwind数据库和我能找到的每个AdventureWorks数据库。



我的第一个问题是当我使用此代码检测家庭网络上运行的所有PC时，组合框中显示的唯一PC名称是我的Windows 8 PC（MRM-WIN8-DT）。

Hello Everyone:
I still can''t access the databases stored on MRM-DT-002. The system crashed on me so after I restored it I installed MS SQL Server 2008 Standard and installed the Northwind database and every AdventureWorks database I could find.

My first problem is when I use this code to detect all the PC''s running on my home network the only PC name showing up in the combobox is my Windows 8 PC(MRM-WIN8-DT).

Private Sub cboSvrName_DropDown(ByVal sender As Object, _
                                    ByVal e As System.EventArgs) _
                                    Handles cboSvrName.DropDown
        'List all servers both local and non-local
        Dim dt = SmoApplication.EnumAvailableSqlServers(False)
        Cursor.Current = Cursors.WaitCursor
        cboSvrName.ValueMember = "Name"
        cboSvrName.DataSource = dt
        Cursor.Current = Cursors.Default
    End Sub

我的工作区布局方式是：MRM-DT-002和MRM-WIN8-DT连接到我的AT& T无线调制解调器。此调制解调器将两台PC连接到Internet。



我肯定我错过了一些基本的东西，因为我的Windows 8 PC没有看到安装了SQL Server的Windows XP PC。 br />


有人能指出我正确的方向吗？如果我可以让我的Windows 8 PC与我的Windows XP PC对话，那么我可以访问数据库并转到下一个问题。



非常感谢，

MRM256

The way I have my work area laid out is: MRM-DT-002 and MRM-WIN8-DT are connected to my AT&T Wireless Modem. This modem connects both PCs to the Internet.

I''m sure I''m missing something basic because my Windows 8 PC isn''t seeing the Windows XP PC where I have SQL Server installed.

Can someone point me in the right direction? If I can get my Windows 8 PC to talk to my Windows XP PC maybe I can then access the databases and go to the next problem.

Many Thanks,
MRM256

推荐答案

请查看 SQL Server配置管理器并确保 SQL Server浏览器正在运行。



在以下来自Microsoft SQL Server论坛的帖子中，还有一些其他提示可以帮助您。请参阅通过家庭网络共享SQL服务器的问题 [ ^ ]

Please look at SQL Server Configuration Manager and ensure that the SQL Server Browser is running.

In the following posting from the Microsoft SQL Server Forum, there are several other tips that may help you. See Problem sharing SQL server over a home network[^]

防火墙问题？

你可以ping你的XP机器吗？如果没有，请启用ICMP echo requests。

同时配置SQL Server以允许来自不同计算机的连接 - 默认情况下已关闭。

A firewall issue?
Can you ping your XP machine? If not, enable "ICMP echo requests".
Also configure your SQL Server to allow for connections from different computers - that''s switched off by default.

我缺少的是：

我必须将MRM-DT-002上的操作系统更改为Windows Server 2003 R2以解决问题。



看起来我原来问题中的代码片段仅适用于运行服务器操作系统的PC。



感谢大家给我一个关于如何修复的建议问题。



MRM256

What I was missing is:
I had to change the OS on MRM-DT-002 to Windows Server 2003 R2 to fix the problem.

It looks like that code snippet in my original question only works with PCs running a Server OS.

Thanks to everyone who gave me a suggestion on how to fix the problem.

MRM256

这篇关于我遗漏了一些基本的东西的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！