Doubliewkay: 2009年6月

6月1日

Having some problems connecting .NET Windows application or Web application to a remote SQL Server 2008 on a Windows Server 2008?

Here are some troubleshooting guides:

Run SQL Server Configuration Manager. Expand SQL Server Network Configuration and select Protocols for MSSQLSERVER. Make sure Named Pipes and TCP/IP are enabled.
Run Windows Firewall. Click on "Allow a program through Windows Firewall". Check if port 1433 is allowed. If not, then click on "Add port...". Add the following details; Name = Port 1433 - SQL Server 2008, Port = 1433, Protocol = TCP.
If you are also accessing SQL Server Reporting Services reports, check if port 80 is allowed. If not, then click on "Add port...". Add the following details; Name = Port 80 - HTTP, Port = 80, Protocol = TCP.

First, check the Device Manager of the Hyper-V virtual machine.

Is there any warning or problems with the Virtual Machine Bus?

Basically, the HAL detection when Integration Services Installed is not working properly

So here are the steps to resolve it.

1) run msconfig

2) go into Advanced Boot options

3.) Click Detect HAL

4) Reboot

Check the Device Manager again. The Virtual Machine Bus device should be resolved.

Finally, install the Hyper-V Integration Services.

Are you having problem adding a Loopback Adapter in Windows 7?

The "Add a device" can't find any suitable hardware?

1) Type "hdwwiz.exe" in the Run command.

2) Click Next.

3) Then select the "Advanced" option.

4) Select "Network Adapter".

5) Choose "Microsoft" and "Microsoft Loopback Adapter"

And you have just installed the adapter.

If you are unable to ping a freshly built Windows Server 2008, though you confirmed the IP address of the server.

The reason is because by default, the Windows Server 2008 Firewall is configured to disallow the "File and Printer Sharing" feature.

Hence, this blocks the ICMP Echo Request packets used by the PING command.

Enabling the "File and Printer Sharing" in the Windows Server 2008 Firewall, will enable you to ping the server from remote machines.