QuoteWerks Help > CHAPTER 33: QuoteWerks Web > Setting Up QuoteWerks Web > 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.

QuoteWerks Web Setup (Starting with Microsoft SQL Backend)

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, the Desktop version of QuoteWerks that you are rehosting needs to have an external static ip address. You will need to provide this when requesting your QuoteWerks Database hosting service details. This is used to whitelist your external static ip address with the hosting service.

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, follow the instructions in the topic Setting up QuoteWerks Web in QuoteWerks Desktop.

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 address of 209.208.98.51.

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 address of 209.208.98.51.

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