Hi,

Background

Windows 2012 R2 and SQL 2012 SP2 2 nodes cluster with Quorum, MSDTC and multiple SQL instances

Node1 - 192.168.1.1 HeartBeat 10.0.0.1

Node2 - 192.168.1.2 HeartBeat 10.0.0.2

vClustername  - 192.168.1.3

vSQLname1\Instance1 - 192.168.1.4

vSLQname2\Instance2 - 192.168.1.5

Ping all names included virtual names - no issue.

\\node1\c$, \\node1\d$, \\node1\e$ and etc - all no issue.

But \\vSQLname1\c$ \\\\vSQLname1\d$, \\vSQLname1\e$ and etc - all failed (understand that it is by design).

Question

1. Do I need to add MSDTC resources to vSQLinstance1 and vSQLinstance2?

2. How to configure application to communicate \\vSQLname\instance1? As it is unable to map \\vSQLname\e.

Please advice.  Thanks.

>How to configure application to communicate \\vSQLname\instance1?

Assuming you mean \\vSQLname1\instance1,

Either configure the application to use the named instance, and run the SQL Browser service, or configure the instance to listen on port 1433 of its IP (192.168.1.4) and configure the client app to connect to vSQLname1.

Why are you trying to connect to the Windows admin shares on the cluster?

David

Hi David,

Lync 2013 topology builder is creating DB using vSQLname\instance1 but operation failed because of missing file \vSQLname\e$.  That's why I tried to map \\vSQLname\e$ (for testing purposes).

Telnet vSQLname 1433 no issue. Checked SQL Browser service is started on both nodes.

Regards,

\\vSQLname\e$ is a File Share; it has nothing to do with SQL Server.  If you need to create a clustered file share, that's a separate process from installing a SQL Server Failover Cluster Instance.  eg

Checklist: Create a Clustered File Server

David

Hi David,

Issue fixed by configured Alias\TCP/IP using SQL Server client Network Utility as well as selected "Use SQL Server instance defaults" from Lync Topology.

Next question is DTC,  should I add DTC to all instances?

Regards,

Hi Kelvin,

If your application calls DTC directly or if you use a feature in SQL Server that calls DTC, then you need DTC to be available.

Some examples of how SQL Server uses DTC: linked servers, OPENROWSET, OPENQUERY, OPENDATASOURCE, remote procedure calls, BEGIN DISTRIBUTED TRANSACTION, updatable subscriptions for transactional replication.

Reference:
Do I need DTC for my SQL Server?
How to Properly Configure DTC for Clustered Instances of SQL Server

Thanks,
Lydia Zhang

If you have any feedback on our support, please click here.

Thanks Lydia.  I think DTC instances are not necessary for Lync 2013 DBs and OneDrive for Biz DB.

Correct me if I am wrong.

Re

Hi Kelvin,

Yes. If you don't use these DTC examples for Lync 2013 DBs and OneDrive for Biz DB, there is no need to add DTC for your instances.


Thanks,
Lydia Zhang

Hi Lydia,

I think DTC per instance is required for active active.

Please advice.  Thanks.