Important: The following setup instructions are for advanced IT Administrators. Experience with firewalls, IP Address and Port management, 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. |
Below are steps to integrate QuoteWerks Web with your on-premise QuoteWerks Microsoft SQL Database.
Overview:
From a high-level there are only 2 steps required to integrate QuoteWerks Web with your on-premises QuoteWerks Database.
1.Configure your hardware firewall to route incoming SQL traffic to your Windows Server that is running Microsoft SQL Server and limit access to only the IP address of the QuoteWerks Web server.
2.Configure the firewall on your Windows Server (that the SQL Server is on) to not block the incoming traffic that you just routed from the hardware firewall to your SQL Server.
Once completed the last step will be to complete the QuoteWerks Web setup process in QuoteWerks.
Setup Instructions:
Important: Please note firewall administration is outside the scope of this document. The steps provided below are simply to point you in the right direction. Please consult your firewall administrator for further assistance. |
1.Configuring your firewall to route incoming SQL traffic to your SQL Server
a.On your hardware firewall/router, add a port forwarding rule / entry in your firewall to forward external SQL port (default is TCP/IP 1433) requests to your internal SQL Server.
2.Configure the firewall on your Windows Server (that the SQL Server is on) to not block the incoming traffic on port 1433 that you just routed from the hardware firewall to your SQL Server.
Whitelisting Guidelines:
1.Configure your firewall to limit incoming SQL Server port access to Only QuoteWerks Web's IP Addresses (52.237.138.167 and 209.208.98.51).
2.We strongly recommend you change your SQL Server from the default port of 1433 (or even just the external port portion of the port-forwarding rule if your firewall supports this).
Additional Notes
A simple way to determine your external IP address is by Googling: "external ip address". Google provides your Public IP address at the very top of the search results.
Also sites like https://www.whatismyip.com/ will provide you your public IP address.
For more information on configuring your Windows Firewall to allow SQL Server Access see:
Final Setup Steps
After the above steps have been completed, you can continue to the final steps of setting up QuoteWerks Web.
