Servicing Director requires Microsoft SQL Server for the database server, and the Microsoft SQL Server software must be configured with the settings described below.

You must manually install SQL Server and the appropriate service pack before you install the Servicing Director databases. For detailed information about installing, configuring, and managing SQL Server, see your Microsoft SQL Server product documentation and support resources. 

Review the following:

• System Requirements for Servicing Director article in Knowledge Center
• Servicing Director Installation Guide on Support Center (Solutions > Servicing Director > Product Documentation) 
• Servicing Director Backups article in Knowledge Center 

General SQL Server information:

• You can use Servicing Director on the Microsoft SQL Server full editions Standard, Enterprise, or DataCenter. 

• You can also use Servicing Director on the free to download, but limited, Microsoft SQL Server Express edition. The Microsoft product bundle SQL Server Express with Advanced Services is the recommended SQL Server Express installation to use.
  
  Note: SQL Server Express is limited to 1 processor, 1GB of RAM memory, and maximum database sizes of 4GB for SQL 2008 and 10GB for SQL 2008 R2. Depending on your business use of Servicing Director, these limited resources may make SQL Server Express inadequate for your business. SQL Server Express will have slower performance, so while you do not have a user limit, the more users you have, the slower SQL Server Express will perform, especially during high demand periods such as during extensive reporting and calculations. Also, with SQL Server Express, the database sizes will eventually stop new loan transactions from being added to the system when the database limit is reached. SQL Server Express can be a good choice for a test server.

• You can estimate using about 1GB of database space per 1000 Servicing Director loans. Your usage may vary. Most Servicing Director data accumulates over time, providing a full audit and historical record on every loan, permanently storing most data whether or not a loan is actively being serviced or not. Using Servicing Director will typically cause the database size to grow over time, and there are no significant product provided methods to reduce the size of the database. Therefore, leave the SQL Server default setting enabled to allow databases to automatically grow or manage the disk space available to allow for the growing database size.
• Servicing Director databases are installed with the SQL Server Simple recovery model. You can change the recovery model, but you will be required to manage the transaction log created by other recovery models. For more information about recovery models and database backups, see your Microsoft SQL Server documentation.
• Servicing Director databases will be installed with SQL Server compatibility level 90 (SQL Server 2005). This is the required level for Servicing Director, and higher levels are not supported at this time.
• SQL Server named instances can be used for the Servicing Director databases.

• SQL Server Cluster servers are not supported for Servicing Director. The Servicing Director database is not tested or designed for a SQL Cluster server.

• SQL Server database replication is not supported for Servicing Director. The Servicing Director database product is not tested or designed for a database with replication enabled. If replication is enabled, the Servicing Director database upgrades may fail to upgrade the replicated parts of Servicing Director without displaying an error, and report the upgrade was successfully completed. Also, some Servicing Director SQL Server transactions fail when replication is enabled on some Servicing Director tables.

• Microsoft SQL Server Service Packs are supported for Servicing Director. You should apply any Microsoft recommended Service Packs to your SQL Server.

• Virtual Windows servers which meet the System Requirements qualify as Windows servers for your Servicing Director SQL Server. However, many customers achieve faster performing SQL Servers when their Windows platform is a dedicated physical server rather than a virtual server.

When you install SQL Server, you must select the following SQL Server configuration settings:

• Backward Compatibility: You must install the SQL Server Client Backward Compatibility components.
  
  For full editions of SQL Server, during the SQL Server Setup Feature Selection, select the Client Tools Backward Compatibility feature to install the Backward Compatibility components. 
  
  For SQL Server Express, the SQL Server installation does not offer the Backward Compatibility feature, so you need to add-on the Backward Compatibility components after you install SQL Server Express. You can download Backward Compatibility components from the Microsoft support downloads web site, and it will be packaged individually as the SQL Server 2005 Backward Compatibility Components or bundled in the Microsoft SQL Server 2008 Feature Pack. The 2005 Backward Compatibility Components are suitable for SQL 2008, and SQL 2008 R2.
  
  If the Servicing Director Databases installation does not find the SQL Server 2005 Backward Compatibility Components already installed, it will automatically launch the Microsoft installer for these components before proceeding with the installation of Servicing Director databases.

• Management Tools: Servicing Director rarely requires you to use the SQL Server Management tool called SQL Server Management Studio, but you may need it at some point. Therefore, install the SQL Server management tools. 
  
  For full editions of SQL Server, during the SQL Server Setup Feature Selection, select the Management Tools - Complete feature to install the SQL Server Management Studio and other tools.
  
  For SQL Server Express, the Microsoft product bundle SQL Server Express with Advanced Services provides the Management Tools feature, which installs the limited SQL Server Management Studio Express application. During the SQL Server Setup Feature Selection, select the Management Tools - Basic feature to install the SQL Server Management Studio Express. You can also download SQL Server Management Studio Express from the Microsoft support downloads web site.

• Windows service account: Select a Windows service logon account with elevated privileges such as the local system account or a suitable domain account. Servicing Director will use SQL Server to access the Windows registry or other areas requiring elevated privileges.

• Collation sequence: Select the default collation of SQL_Latin1_General_CP1_CI_AS. The SQL Server collation sequence is set during the SQL Server installation and cannot be changed.
• Authentication mode: Select SQL Server and Windows authentication (also referred to as mixed mode authentication). The SQL Server and Windows authentication mode is required for Servicing Director. With SQL Server and Windows authentication, you will be prompted to enter your choice of the SQL Server system administrator "sa" login password. Save this "sa" login password for later use, because the Servicing Director database installation and upgrades, as well as other SQL Server administrator tasks will require this login and password.

After you have installed SQL Server or SQL Server Express, you must do the following:

• Enable SQL OLE Automation Procedures. The current values for these options can be viewed and changed by using the sp_configure system stored procedure. For detailed information about configuring SQL Server, see the Microsoft documentation. Perform this procedure once for a new installation of SQL Server.
• Confirm the SQL Server Network Configuration enables the TCP/IP protocol. 
• If you have more than one SQL Server instance on the server, you may need the SQL Server Browser service to be started and configured with startup type automatic.

You should also do the following after the Servicing Director database is installed on the SQL Server:

• Configure your backup tools to back up the databases named Service and SvcEventMgr.
• Complete a new set of backups on the new server. 

ArticleNumber:

000053812