Hi there, the same is my problem. Our application also uses the Computer Name. I don't have an idea about adding the computer name of Mirrored Server in order to make it available to Application Server. Your help shall be appreciated.
P.S. I'd be grateful if you can provide me with descriptive solution.
This would depend on how the application is configured to connect to the SQL instance and which network Library the SQl instance is configured to listen for incoming connections. For example, if the SQL instance is using the Named Pipes network library, then this is using NetBIOS. This would require that the Swtich HOst Name method of redirection be used. The Switch host Name will rename the Master server by appending its name with a "-xo". In newer versions of the product (Ca ARCserve RHA), it will rename it with a "-RHA". The Replica server would then be renamed to the name of the master. The Dynamic DNS Flag on the interface (Register This connection with DNS) would then update the Master A-record and assign the IP address of the replica. This way regardless of whether the client or server applications are using NetBIOS or DNS resolution, they would be redirected to the replica.
Switch Host Name would also resolve issues with the Master host name in the system tables being replicated to the replica. The other option would be to use REdirect DNS, then use the commands I listed earlier to set the replica server name. This stored procedure could be included in a User Defined Script to be executed on the replica following a successful switchover.
I hope this clarifies things. Please feel free to let me know if you need clarification.