I just upgraded my test Active/Active cluster from sql 2000 sp4a to SQL 2005. While the sql instance that normally runs on node2 was failed over to node1 instance2 refused remote connections. I have not had a chance to test failover the other way (all instances to node2). Obviously this defeats the purpose of clustering.
What am I missing in the setup or config?
Failover worked both ways prior to the upgrade.
Both instances running on different port numbers ? you can't share port 1433 for tw instances o one machine !
Make sure that for example instance 1 is always running 1433 and instance 2 is always running
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…