1 Reply Latest reply on Feb 6, 2015 1:27 PM by jaminsql

    Change server display name

    hodgese

      We tend to use DNS aliases for most of our sql servers here. Is there a way that I can change the display names of the servers in DPA to match the alias? I noted that if I put the alias in when adding the server to DPA, it converts it to the computer's actual name.

       

      This would be a big help for our developers, who are used to referring to the servers by their aliases.

       

      Thanks,

      Eric

        • Re: Change server display name
          jaminsql

          This can be done.

          click on Options > Database Query Tool (support tab) and run the following SQL statements:

           

          -- grab the ID for the  instance and use in the UPDATE statement
          select * from cond

          -- Set the Display name to the alias
          update cond set
          name='<New Display Name>' where ID = <ID of instance to change>

           

          restart DPA ignite PI service to pick up the change.