1. Go to Database login and create a new login.
  2. Use SQL Authentication:
UserName: REConn
Password: xxxx
Choose the RE7 database as the default database
  1. BEFORE clicking OK, click on "User Mapping" on the left of the dialog.
Check the box for the RE7 Database
The REConn user should show up
At the bottom make sure the role "db_datareader" is checked.
  1. Then click OK and verify that it created a user called REConn on the RE7 database
  2. Test: Disconnect from the server and reconnect using SQL authentication and the REConn credentials.
  3. Restart the apache RE Connector to see if it is working.