Configuring the SQL server to communicate with BioBridge - IDEMIA Biometrics 3.1

To allow the BioBridge to connect to the Morpho Biometrics plugin, the Morpho BioBridge must have access to the SQL database of the plugin.

1. In Windows, open SQL Server Management Studio.
2. In Object Explorer, right-click on your SQL instance, and select Properties.
3. In Server Properties - your SQL instance > Security > Server Authentication, select SQL Server and Windows Authentication mode.
4. In Server Properties - your SQL instance > Security > Server Authentication, select Allow remote connections to this server and click OK.
5. In Server Properties - your SQL instance > Security, right-click on Login.
6. In Login - New > General, do the following:
   1. Enter a login name.
   2. Select SQL Server authentication.
   3. Enter and confirm a password.
   4. Make sure that Enforce password policy, Enforce password expiration, and User must change password at next login are unselected.
   IMPORTANT: If there is a password policy in effect, the integration can stop working without notice if it is unable to log into the database. If the password needs to be changed, you must update the password in the MorphoManager SQL DSN to ensure the integration continues to operate.
7. In Login - New > User Mapping, do the following:
   1. In the Users mapped to this login section, select the MorphoBiometricsplugin database.
   2. In the Database role membership for: MorphoBiometricsplugin section, select db_owner.
   3. Click OK.
   IMPORTANT: Do not give this user account system administrator rights.
8. Close SQL Server Management Studio.
9. Open SQL Server Configuration Manager.
10. In SQL Server Network Configuration > Protocols for MSSQLSERVER, do the following:
    1. Right-click on TCP/IP and select Properties.
    2. From the Enabled list, select Yes.
11. Click Apply and then click OK.
12. Restart your SQL Server.
    IMPORTANT: If you do not restart the SQL Server, some of the above changes may not take effect and can prevent the integration from functioning correctly.

    Watch this video to learn more. Click the Captions icon (CC) to turn on video captions in one of the available languages.