QuoteWerks Web Setup (Starting with Microsoft SQL Backend)

Important: The following setup instructions are for advanced IT Administrators. Experience with firewalls, and Microsoft SQL Server is required to complete these steps. DO NOT attempt to follow the instructions below if you do not have the above mentioned experience.

If the backend of your installation is already hosted on Microsoft SQL, you have several options on how to proceed depending upon if you want keep your existing SQL database or move it to a different hosted location

Select your scenario and then follow the corresponding steps below to properly setup your installation for QuoteWerks Web.

Tip:	If you would like assistance with this setup process, our Professional Services team can assist you for $100hr.

Your Microsoft SQL Database is currently located on an on-premise Microsoft SQL Server:

A.You can: Keep your SQL Database on your on-premise Microsoft SQL Server:

1.First, follow the instructions in the topic Configuring Your Firewall for QuoteWerks Web On-Premise Database Hosting.

2.Second, follow the instructions for Setting Up QuoteWerks Web in QuoteWerks Desktop.

B.You can: Rehost to QuoteWerks Database Hosting Service:

1.First, contact QuoteWerks Technical Support and ask for the instructions for migrating a QuoteWerks SQL Database from one SQL server to another.

2.Second, follow the instructions in the topic Setting up QuoteWerks Web in QuoteWerks Desktop with the QuoteWerks Database Hosting Service.

C.You can: Rehost to a 3rd-party Database Hosting Provider (Amazon, Azure, etc.):

1.First, the Desktop version of QuoteWerks that you are rehosting needs to have an external static ip address. You will need to whitelist your external static ip address with the 3rd-party Database Hosting Provider.

2.Second, contact QuoteWerks Technical Support and ask for the instructions for migrating a QuoteWerks SQL Database from one SQL server to another.

3.Third, configure the 3rd-party Database Hosting Provider's firewall to provide access to QuoteWerks Web. This means whitelisting the QuoteWerks Web IP addresses of 209.208.98.51 and also 52.237.138.167.

4.Fourth, follow the instructions in the topic Setting up QuoteWerks Web in QuoteWerks Desktop.

Your Microsoft SQL Database is currently located on a 3rd-party Database Hosting Provider (Amazon, Azure, etc.):

D.You are already rehosted, so you just need to configure for QuoteWerks Web:

1.First, configure the 3rd-party Database Hosting Provider's firewall to provide access to QuoteWerks Web. This means whitelisting the QuoteWerks Web IP addresses of 209.208.98.51 and also 52.237.138.167.

2.Second, follow the instructions in the topic Setting up QuoteWerks Web in QuoteWerks Desktop.