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