• No I didn't rename the windows server.

    I have couple of SQL Instances running on the server.

    I have a one named instance running on this computer, which i want to change.

    I don't want to change the server name.

    -------------------------------------------------

    If this is not the solution then i can create an alias for the server. This i want to do it on the server, i dont want to do any settings on the client computers.

    Bottom Line :

    -We want to shutdown the Live Server (SqlLive)

    - On the Test Box : Rename the SQL Server Instance name to (SqlLive) OR Create an alias SqlLive

    - Test the Applications using the Test Box.