"Greg Larsen" <gregalarsen@removeit.msn.com> wrote in message
news:4C09B928-F13B-4C4F-A0FD-4CCA60F1359C@microsoft.com...
> I'm setting up SQL Server 2005 and would like to develop a new application
> architecture. Here are my objectives:
> 1) I want to be able to move a database from one SQL Server machine to
> another without having to recode connection strings in applications.
> 2) I want to be able to redirect applications connections from one server
> to
> another and only change relocation information in single place.
> 3) I want to use non-standard port with SQL Browser not running.
>
> Basically I would like to set up something that would redirect names like:
>
> AP1V1P ==> IP address 1
> AP1V1Q ==> IP address 2
> AP1V1D ==> IP address 3
> AP2V1P ==> IP address 1
> AP2V1Q ==> IP address 2
> AP2V1Q ==> IP address 3
>
> All the names that start with AP.. would be coded in the applications.
>
>
> Can I use DNS to resolve all connection? Will DNS work for all
> application
> connections regardless of connection provider protocol?