Rehost QuoteWerks Desktop (Access backend) to 3rd Party Hosting Provider

<< Click to Display Table of Contents >>

Navigation:  QuoteWerks Help > CHAPTER 33: QuoteWerks Web > Setting Up QuoteWerks Web >

Rehost QuoteWerks Desktop (Access backend) to 3rd Party Hosting Provider

To re-host the QuoteWerks Desktop (with Access backend) to a 3rd party hosting provider (Amazon, Azure, etc) follow the steps below.

Important:   If your installation has already been rehosted to SQL and you want to use a 3rd party provider, you WILL NOT be able to follow the below instructions. If this is the case, please contact technical support for instructions on moving from an already rehosted installation to a 3rd party hosted option.

Step 1: Click the Utilities -> Rehost Backend to SQL menu. The Welcome window will appear:

Important:   The Utilities -> Rehost Backend to SQL menu may not be enabled. For it to be enabled, the following three conditions must be met:

1.QuoteWerks must currently be using the Access backend.

2.A Corporate Edition License Key must be entered in this installation.

3.The user who’s logged in to QuoteWerks must have QuoteWerks Master Rights.

Click on the [Next] button to start.

 

Step 2: On this window click "SQL Server authentication".  Next, enter the server. If using Amazon it will look similar to xxxx.xxxx.xxxx.rds.amazonaws.com or something similar.  Then enter the username and password provided by the 3rd party hosting company in the User ID and Password fields. Finally, give the database a name (QuoteWerks is recommended).  Leave the database owner as dbo.  

Check the box that says "Copy data from the current Access databases to the new SQL database" if applicable.  

 

 

Note:Unless you are an expert with the use of SQL Server, it is generally not suggested to change the the Database Owner from the default "dbo".

 

Step 3: Click on the [Next] button to start the re-host process. A progress monitor displays during the re-hosting process.

This step may take anywhere from a few minutes to a few hours, depending on how much data your QuoteWerks installation contains. Please be patient.

 

Step 4: Click on the [Finish] button to complete the re-host process.

 

After the rehost has completed, you can continue to the final steps of setting up QuoteWerks Web.