Query

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:

> 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
>
|||"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:4666A2EA-AB16-4CD0-B53A-533EC5D93713@.microsoft.com...
> 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.
>
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.
[vbcol=seagreen]
> Regards
> Mike
> "Sachi" wrote:
to[vbcol=seagreen]