Configuring asp.net application to talk to a mirrored SQL Server 2005

The best (possibly it's the only right) choice is to build
an SQL Server
cluster.
http://www.microsoft.com/sql/technologies
/highavailability/default.mspx

Regards,
Artem

-----Original Message-----
Subject: [DOTNET-WEB] Configuring asp.net application to
talk to a mirrored
SQL Server 2005

I am looking at the possibility of using the database
mirroring using SQL
Server 2005. However, I am not sure how to configure the
asp.net
applications to use the mirrored database, because if the
primary database
server fails, how will the application know to connect to
the secondary? Is
there a way to specify a failover database in the connection
string?

Thanks

Arvinder Chopra

===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com