POS/Store Manager: "Timeout expired. The timeout period elapsed." error

Description: The error message "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." displays.

Background info: A connection pool is a cache of open database connections. It simplifies the process of sending requests to the store database by allowing apps to borrow an open connection instead of creating a new one. When the request is completed, the connection is returned to the pool. Each connection string has its own connection pool. For diagnostic purposes, RMH includes the name of the app in connection strings.

Troubleshooting:

• Close RMH apps at the end of the day to close open connections and release resources to the SQL Server.
• If necessary, reboot the SQL Server. This can be difficult to do if the store operates 24/7.