But what about the client connections? They will actually redirect themselves using a process called Transparent Client Redirection assuming you are using the SQL Native Client or ADO.Net 2.0 or above ...