CODEWITHSUNDEEP
sql-servercluster-computing
Sam
Sam

Reputation: 7678

SQL Cluster - using datasource (local)

Using (local) in the connection string doesn't work on my cluster. I'm assuming it's looking for the default instance on the currently active node instead of the Virtual SQL name. Anyone know how to make this work?

edit note: I'd like to use (local) and not localhost - I don't want to change any application generated code.

Upvotes: 4

Views: 943

Answers (3)

Mitch Schroeter
Mitch Schroeter

Reputation: 1001

The names (local) or (.) will always use the shared memory interface, rather than TCP or Named Pipes, and neither can be used against a clustered instance which requires TCP or Named Pipes over TCP. You can't 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.

Upvotes: 3

Nick Kavadias
Nick Kavadias

Reputation: 7338

You must use the clustered Virtual SQL Service name, unfortunately localhost and (local) do not work on a cluster

Upvotes: 1

coding Bott
coding Bott

Reputation: 4357

have you tried "localhost" without ( and )

Upvotes: 0

Related Questions