Updates for Backend SQL Server
This section describes the changes required to run when customer databases are deployed on an external SQL backend server.
The Backend SQL server username and password must be identical to the service account used for the installation of the UMP server. Create the following directory for database backup for Wyupdates:
c:/acs/dbbackup/
| ➢ | Do the following: |
| 1. | Enable Firewall rules to allow connection from remote to the DB (TCP 1433, 4022, 135, 1434, UDP 1434). |
| 2. | Enable the SQLBrowser service: |
| 3. | Enable SQL TCP/IP connection. |
| 4. | Open the Sql Server Configuration Manager (under Protocols for SQLSYSADMIN) and set TCP/IP to Enabled. |
