Common Issues faced as part of implementing Delphix SQL Server.
Issues Registering Source Environment:
- Check if staging/target (proxy) server is registered first.
- Check to make sure Delphix Connector running on Staging/Target (proxy) server.
- Make sure source AD account is part of windows Administrator or Backup Operators group. Refer to Database User Requirements for SQL Server.
- Make sure source AD account has read access to Master database on source. Refer to Database User Requirements for SQL Server.
- Make sure "Log On As Batch Job" permission exists for source AD account on staging/target (proxy) server. Refer to Database User Requirements for SQL Server.
- If hostnames didn't work, try registering using IP address.
Issues Registering Staging/Target Server
- Check Delphix Connector service is running.
- Check if no firewall is running on staging/target server.
- Verify and make sure AD account has proper windows and SQL instance level privileges. Refer to Database User Requirements for SQL Server.