Before you begin, close out of REA 10 and any Microsoft Office products you currently have open.
First, we will need a backup of your REA 10 database. To create a backup, simply go to File > Backup in REA 10 and select a location to back the database up to. If you are creating the backup on another computer, you will need to transfer the Zip file that is created to the workstation computer that you will be installing REA 10 onto, usually done via a USB stick or a network drive.
Next, you will need to download the Complete version of REA 10 to the server. To do that, go to the following website: http://reaupd.realnex.com/ and click Login at the top. Enter the following information:
Login: The user’s email address
Password: If you’ve forgotten your password, click Forgot your password to have it emailed to you
Once logged in, click My Updates at the top. Download the file labelled as complete.
Once the file has downloaded, run the file. It should come up with a list of pre-requisites. Let these install. When you get a message asking you if you would like to install Microsoft SQL Server (optional), click Yes. The installation will the come up. You will be asked for a password and to confirm the password. Create a password here. The password must be at least 8 characters, contain at least 1 number and 1 capital letter, and cannot have the user’s name or initials in the password. Once you enter the password, continue the remainder of the installation of Microsoft SQL Server.
After Microsoft SQL Server installs, it will bring up a window to install REA 10. Click Next on this window until you see an option for setup type. Select "Complete" and continue and finish the installation.
Once the installation is complete, go to Start and right-click on Computer and go to Properties. Make a note of what the Computer Name shows here, as that will be needed shortly.
Next, go to Start > All Programs > REA Inc > Database Tools > Database Manager. Click the Connect button. Where it shows Server, enter the Computer Name from above, followed by \REA. The entire string should show COMPUTERNAME\REA. Click on Use SQL Server Authentication and enter the password you provided during the installation of Microsoft SQL Server above. Click OK.
Next, click Restore. Locate the backup file you created from the network database and click Open. Click the Restore button. If it prompts you stating that the “Database you are restoring over is not the one this backup was originally made from…”, keep the default option selected and click OK. Once the backup has completed, click OK. If you are prompted about user accounts here, click “Yes”. Otherwise, click the User Accounts button in the Database Manager.
In the user accounts window, first, click on one of the users that will not be using this local copy of REA 10 and click Edit. Uncheck the box that says “Account is enabled” and click OK. Click No on the prompt about deleting the login for this user. Do the same for any other users that will not be using this database.
Next, click on the user for whom this database is being installed for and click Edit. Make sure that Account is Enabled and Administrator are checked. Make a note of the Login and click Change Password. Choose a password. Once you’ve created a password and made note of the login, click OK, then Close on the User Accounts Window. Close the Database Manager.
Now, open REA 10.
You should now see the login screen. For Server, enter the server name from above that had COMPUTERNAME\REA and enter this user’s Login and Password for REA 10. Click Login. You will be asked about registering the product. Within the next 30 days, you will need to click Yes on that message, click Request Key and on the page that comes up, enter the user’s information in the Required fields and click Submit. We will send a license key with instructions on registering the program shortly thereafter.