SQL Cluster - using datasource (local)

views:

176

answers:

+3 Q:

SQL Cluster - using datasource (local)

Hi, 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.

have you tried "localhost" without ( and )

Bernd Ott 2009-01-09 21:31:18

Certain programs use (local), which is a sql connection string keyword apparently. My goal is to not have to get into the vendor supplied application and change it, otherwise I would just change it to the virtual SQL name.

Sam 2009-01-09 23:57:10

i know (local) only when you try to access an special instance.the cluster works on his virtual ip.

Bernd Ott 2009-01-11 18:28:31

+1 A:

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

Nick Kavadias 2009-01-10 01:15:01

+3 A:

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.

Mitch Schroeter 2009-01-12 04:28:13

ansaurus

tags:

views:

answers:

SQL Cluster - using datasource (local)

related questions