Microsoft SQL Server MDB Considerations › Environment

Environment

Microsoft SQL Server can be installed on the same server as other applications but consider the following:

• Installing Microsoft SQL Server on a dedicated computer may improve performance.
• Depending on the number of processors, memory, and disks on your computer, a dedicated computer may not be required. Network latency between the application and the SQL Server may in fact degrade application performance.

Case Sensitivity

The SQL Server instance that hosts the MDB can either be case sensitive or case insensitive. The MDB is created as a case insensitive database.

If the SQL Server instance is defined as case sensitive, all connection requests to the MDB must specify the database name (mdb) in lower case. If the database instance is defined as case insensitive it does not matter what case is used in the database name when connecting to the MDB.