Hi,
We are planning to make clustering with our SQL Server database in our
main servier.
But I heard once it is been done, all the application which is point to
this database should be rework.
Is it true?If soo how is it?

Regards,
Sachi

Hi

Clustering does not affect the way an application sees a SQL Server. With
Windows clustering, you connect to a Virtual Name, and not the specific
machine name, no matter what instance is running.

As long as you can configure you application to use the cluster's name, you
have no problems.

Regards

Mike

"Sachi" wrote:

"Mike Epprecht (SQL MVP)" <mike (AT) epprecht (DOT) net> wrote

I think what he's probably referring to is that in the event of a fail-over,
a well designed app will retry the query w/o giving an error while the
cluster is in the process of failing over and no server is running at that
moment or if it occurs in the middle of a transaction.