"Uri Dimant" wrote:

> Hi Tal
> Yes, I forgot to mention that you have to use ADO.NET or the SQL Native
> Client .
>
>
>
>
> "Tal Bar-Or" <TalBarOr@discussions.microsoft.com> wrote in message
> news:26F6792F-0750-4E87-B438-A602908DA166@microsoft.com...
> > Shalom Uri
> > Thanks for the answer, will it be the right option to use also Microsoft
> > SQL
> > Server Native Client and choosing mirror server will it achieve the same
> > results.
> > Thanks
> >
> >
> > "Uri Dimant" wrote:
> >
> >> Tal shalom
> >> You must specify the initial principal server and database in the
> >> connection string and the failover partner server.
> >> Data Source=myServerAddress;Failover Partner=myMirrorServer;Initial
> >> Catalog=myDataBase;Integrated Security=True;
> >>
> >>
> >>
> >> "Tal Bar-Or" <TalBarOr@discussions.microsoft.com> wrote in message
> >> news:65B28837-DFDB-45A6-858E-F73D291E86F1@microsoft.com...
> >> > Hello,
> >> >
> >> > I have recently installed and configured SQL 2005 SE with database
> >> > mirroring
> >> > configured with high safety with automatic failover synchronous mode.
> >> > My question is (I probably missed the principle idea) in case of
> >> > failover
> >> > occurred how do the clients redirect to the second node transparently.
> >> > Thanks in advanced.
> >>
> >>
> >>
>
>