Use this procedure to create an optional non-system administrator user on the secondary Avaya Control Manager SQL Server with the same name and SID that you use for the user created on the primary Avaya Control Manager SQL Server.
Procedure
Log in to the secondary Avaya Control Manager SQL Server.
Click Start > Microsoft SQL Server > Open SQL Server Management Studio.
In the Object Explorer pane, click Connect > Database Engine.
SQL Server Management Studio displays the Connect to Server dialog box.
In the Server name field, select the local instance of SQL Server.
In the Authentication field, select SQL Server Authentication.
In the Login and Password fields, enter the system administrator credentials.
The system administrator is usually the default sa user created during SQL Server installation.
Click Connect.
In the Object Explorer pane, right-click the SQL Server instance and click New Query.
In the content pane, run the following command to create a new login:
USE [master]
GO
CREATE LOGIN <<same login name as created on the primary EDM>> WITH PASSWORD = '<<password>>', sid = <<same SID as the primary EDM login name>>,
CHECK_POLICY=OFF
For example:
USE [master]
GO
CREATE LOGIN csEDMLogin WITH PASSWORD = 'myPassword1', sid = 0x0589627E7A96D447865135449C41E53B, CHECK_POLICY=OFF
Do the following to manually failover the secondary SQL Server:
Click Always On High Availability > Availability Groups.
Right-click the EDM Availability Group and click Failover.
In the Object Explorer pane, click Security > Logins.
Right-click the newly created login name and click Properties.
SQL Server Management Studio displays the Login Properties dialog box.
In the navigation pane, click General.
In the Default database field, select the EDM database name.
In the navigation pane, click User Mapping.
Select the Map check box for the EDM database.
Click OK.
In the Object Explorer pane, click Databases > <EDM Database> > Security > Users.
Verify that the newly created login name is available in the list of users.
