0
votes
1answer
413 views

SQL Server Virtual Network Name Change Error

I am in the process of configuring a two-node failover cluster for a migration project. We are transitioning a stand-alone SQL Server to a cluster. Environment: 2x nodes with Windows Server 2012 R2 ...
0
votes
0answers
42 views

SQL DTC Failover Scenario

We had an interesting scenario in our clustered production environment last week. SQL 2008/R2 two boxes clustered on Win 2008/R2 in Active/Passive mode. On the active node A, the clustered MS/DTC ...
0
votes
1answer
268 views

SQL Server filestream access from another computer using system account

I have a SQL Server 2008 set up to use filestream. SQL Server runs under a domain account with SPN set and delegation enabled. Accessing filestream from another computer using a domain account works. ...
0
votes
2answers
792 views

Installing SQL Server 2008 SP2 fails in 2003 cluster setup

When I try to install SP2 (or simply "repair" the SQL Server installation), the dependency check finds the following problem: Rule "Not clustered or the cluster service is up and online." failed. ...
0
votes
1answer
101 views

Upgrading 32-bit SQL Server cluster to 64-bit

Here is my situation. $WORK has a trio of three clustered database servers (64-bit Server 2003) that are currently running two SQL Server instances. Unfortunately, when the cluster was set up a ...
0
votes
1answer
543 views

How to implement Peer to peer database replication between two sites?

I am looking for SQL Server database solution which can replicate data between two sites vice versa (not just one way) I’ve looked into SQL Server failover cluster (MSCS) but then since I have two ...
0
votes
1answer
557 views

How do I enable DAC on a clustered SQL Server 2008 after I can no longer connect to SQL Server in any other way

I'm having issues with SQLServer 2008 where a Server level triggered was not dropped correctly. Articles on the web recommend dropping them through the DAC. However, the DAC is disabled by default ...
2
votes
4answers
443 views

SQL server failover clustering

How many failover clustered nodes can you have?, and if you add more and more nodes, is it going to slow down?
2
votes
1answer
432 views

Intermittent unavailability of an instance in a failover cluster while a standby node is offline in a SQL Server 2008 failover cluster

I've got a small failover cluster that I run for the websites my company has. During a RAM upgrade of the standby server, our websites started to show errors about not being able to access the ...
1
vote
2answers
765 views

Two clustered SQL instances on one cluster - same port 1433?

Can two clustered SQL instances on a 2003 windows cluster use the same 1433 tcp port setting reliably? It seems to be up and working right now.
0
votes
1answer
713 views

SQL Clustering vs. SQL VM on a Hyper-V Cluster

In a deployment I'm considering, we have a production sQL server that needs to be highly available. It will be set up on a Server 2008R2 Cluster. Hyper-V will be set up already. I'm worried that ...