The following list outlines the requirements and recommendations for the SQL Server setup.
Requirements:
- Use SQL Server 2014 or above.
- Set up a single domain user with local administrator rights to run the two SQL Server services — MSSQLServer and SQLServerAgent.
Note: You should dedicate this domain account to SQL and set its password to never expire. Set MSSQLServer and SQLServerAgent to auto-start when the operating system starts.
- Ensure that the Server’s default Collation name string includes the CI (case-insensitive) code.
For example: SQL_Latin1_General_CP1_CI_AS is a case- insensitive collation. SQL_Latin1_General_CP1_CS_AS is a case- sensitive collation.
Note: PayGlobal requires Case-Insensitive collation setting. PayGlobal will not work on servers set to use a Binary or Case- Sensitive collation.
Recommendations:
- Database data files and log files should reside on separate physical disks. This setup can help avoid a ‘disk bottleneck’ during high data and log activity. Having log files on a separate disk to the data files also enhances SQL Server data recovery in the event of a system crash.
- Disable the option to Boost SQL Server priority on Windows.
- Configure SQL Mail as part of proactive monitoring of the SQL Server.
- Assign a strong password to the ‘sa’ (system administrator) account.
- Set the security audit level to audit failed logins.
PayGlobal does not use the following:
- DTS
- Full Text Indexing
- SQL Server Replication.
|
