Connect between Onebeat Server to RDS Server

If the client is using RDS server you need to do the following:

In the RDS SQL:

Create new Login:

1. Press right-click on 'Security > New Login
2. Under 'General':
   - Insert a login name 
   - Uncheck 'Enforce password policy, 'Enforce password expiration', 'User must change password at next login'
   - Create a password
   
3. Under 'User Mapping':
   Check the DB you want to use >  check 'db_datareader' & 'db_dataewriter' & 'db_owner > press OK.
   
4. If you'll get an error message> Press 'Ok' > Cancel > You need to see the new user under 'Logins'.
5. Right-click on the new user name> verify that the premission from section 3 has been saved. 

Create 'SymphonyMaster' DB:

1. On the Databases press right-click > 'New database...'
   In 'General' tab - change the below: 
   Database name: SymphonyMaster
   Path: Select the path 'C:\Onebeat Server\' 
   In 'Options' tab - change the below:
   Recovery model: set to 'Simple'
   

2. Run the queries:

Create table dbNameList (
symphonyDBName nvarchar(100)
);

Create table webClientsList (
returnURL nvarchar(200)
)

You need to get a message 'Commands completed successfully.' If you got another message please connect the Support. 

3. Run the query (Replace 'DB_Name' with the real name of the DB) :

insert into [SymphonyMaster].[dbo].[dbNameList]
select 'DB_Name'

In the local server where Onebeat Server is installed on:

Open ‘Onebeat Server Administration’

Open Tab Connection:
Sql Servers:

• SQL location: “ C:\Onebeat Server\”
• Server name: insert the RDS instance(SQL) name > Press 'Add'. 
  If you don't know the RDS instant name: open the SQL > Press on the Plug sign > copy the 'Server name'

• Server list: Choose the correct server name.

Ports Definition:

• Check TCP Port Enabled
• Port Number: ‘20100’

General:
Check Prevent collisions on simultaneous logins

Input file language encoding: 1252 western European

Custom reports export files language encoding: 65001 Unicode (UTF-8).

Open Tab SQL Security:
Choose:

• SQL Server and Windows > Insert the Username and password of 'admin' user you use to connect to the RDS server.