Search code examples
sql-server-2008aliascluster-computingfailover

SQL Server alias for a cluster?

I'm looking for a bit of advice setting up a SQL cluster to be accessed via an alias.

At present, say my cluster is called 'SQLCLUSTER' and I want to set up an alias to redirect to it. Ideally, I'd like any attempt to connect to '(local)' on either of the machines in the cluster to redirect to 'SQLCLUSTER'. I'm using SQL server 2008.

Is this possible with clusters?

Thanks in advance,

Dave

Solution

  • I was able to get this working in the end. It was a case of configuring named pipes correctly, and tweaking a few more SQL server properties (external connections, connection methods and others..)

    Thanks for the contributions.