Enabling the internal database (SQL) authentication and authorization method

The internal database (SQL) method enables the WebOffice EOM to communicate with the Windows Communication Foundation (WFC) service to authenticate and retrieve user information from the NCRWO_WebOfficeSE database.

This task uses the following file.

To configure WebOffice EOM to use the internal database method, follow these steps:

1. Open the web.config file.
2. In the <membership> section, locate the defaultProvider attribute and name key, and change each of their corresponding value to "SqlMembershipProvider". The edited section will look similar to the following sample image.

   

3. In the <appSettings> section, locate the "SecuritySettings" update the value to "RemoteSettings".
   Example

   <add key="SecuritySettings" value="RemoteSettings" />

4. Save the changes.

Defining the connections strings

To define the connection strings, follow these steps:

1. Open a Command Prompt window.
2. At the Command Prompt window, go to the Utilities folder.
   Example

   cd %PROGRAMFILES(X86)%\NCR\DSREnterprise\Utilities

3. Enter the following command:

   Ncr.Retail.SecureConfig.exe –win

   The Secure Configuration utility is displayed.

4. In the ConfigureSetting window, select File.
5. In the Select File/Directory field, do one of the following:
   • Enter the location of the web.config file.
     Example

     %PROGRAMFILES(X86)%\NCR\WebOffice\web.config

   • Select the Browse button to browse for the web.config file.
6. On the ConnectionStrings tab, update the connection strings values of userpreferencedb as necessary.
7. Select Save.