SQL Cluster - using a data source (local)

Question

Using (local) in the connection string does not work in my cluster. I assume it is looking for a default instance for the current active node instead of the virtual SQL name. Does anyone know how to make this work?

Note: I would like to use (local), not localhost - I do not want to change the code created using the application.

Answer 1

Names (local) or (.) Will always use the shared memory interface, not TCP or named pipes, and none of them can be used against a cluster instance that requires TCP or Named Pipes over TCP. You cannot use the shared memory interface against a non-local instance, which in the case of a cluster, the instance may or may not be local.

Answer 2

You must use the cluster name of the virtual SQL service, unfortunately localhost and (local) do not work in the cluster

Answer 3

Have you tried "localhost" without (s)