Connection from a Windows Service could be blocked by firewall even if firewall is disabled

Recently, I worked on a customer issue. The customer encountered an “error: 26 – Error Locating Server/Instance Specified” error  although he has applied/verified every steps I posted in the blog:http://www.bing.com/search?q=error+26+blog+protocol&form=QBRE&qs=n After some investigation, we found that: Windows Firewall is disabled on both server and client machine. Running Portqry from a command window also show that…


Troubleshooting SQL Server Cluster Installations

On a Windows Cluster it is possible to install a SQL Server Cluster, which will be a separate entity with disctinct Virtual Server Name, IP address, and pipe name. The nodes of the SQL Cluster must be able to communicate with one another. This communication may fail if the TCP port on which SQL Server is listening is not…