Server Recommendations

General

We have found that a properly configured and maintained SQL Server will help keep SQL and RFMS running properly.  Maintenance includes backups, but equally important to this would be Database Maintenance.  Proper DB Maintenance helps to ensure that the SQL DB continues to run properly.  Because of this, we recommend MS Best Practices in regards to Network Setup (SQL Server, Application Server, Remote, File Server, etc...)

 Server/SQL Design:

Prior to Purchasing your SQL Server/Microsoft SQL Program. We recommend consulting with your Hardware Vendor, as well as, a SQL DBA as they can assist in determining the best

Server/Configuration for your Environment.

Minimum Common Points to review:

- Drive/Raid Configuration

- Memory Configuration

- Processor Configuration

- SQL Version (Express, Standard, etc...)

- Backup Software / Media

Installation/Configuration:

RFMS recommends MS Best Practices regarding Configuration and Security of SQL. The following

should be reviewed at a minimum:

• SQL Port to Use. SQL uses port 1433/1434 by default. These can be changed after
• Installation for security purposes. Make sure to configure Firewall Ports accordingly.
• Recovery Model to utilize (Simple or Full Recovery Model)
• Database File Storage Location
• SQL Features needed
• Account to use for SQL Services Log On
• Which Protocol to use on Network for SQL (TCP/IP or Named Pipes).

Note: It is usually easier to enable both on the server and then test the workstations out to confirm connectivity. Afterwards, you can restrict at the server via SQL Configuration Manager and then test the workstations again to confirm. Additionally, the SQL Client Configuration Utility (cliconfg) may be needed.

Useful Links:

http://technet.microsoft.com/en-us/library/ms175987%28v=sql.105%29.aspx

http://technet.microsoft.com/en-us/library/cc966412.aspx

http://msdn.microsoft.com/en-us/library/bb500442(v=sql.110).aspx

http://msdn.microsoft.com/en-us/library/bb500442(v=sql.105).aspx