Changing Logical Server Assignments

Alter logical server assignments using Interactive SQL.

  1. Connect to the database as a user with the MANAGE ANY LOGIN POLICY system privilege.
  2. Execute an ALTER LOGIN POLICY statement. The LOGICAL SERVER clause lets you configure values of certain login policy options on a per logical server basis.

    For example, to alter a logical server assignment by assigning logical server ls1 to the login policy lp1, enter:

    ALTER LOGIN POLICY lp1 ADD LOGICAL SERVER ls1
Parent topic: Manage Logical Server Membership
Related reference
ALTER LOGIN POLICY Statement