Previous Topic: Specify ODBC Communication for Remote Database ConfigurationsNext Topic: How to Enable TCP/IP Communication on Microsoft SQL Server Databases


How to Calculate the Number of Required SQL Connections

For each job that you run, you need two SQL connections. Be sure that you have set enough connections (or licenses) in your SQL server. To determine your default SQL connections, select Server and SQL server from the SQL Arcserve Manager. When you browse from the Configuration tab, you can see the user connections. Set these values to the appropriate user setting. If an error message appears, for example, “Cannot Update Record” or “Failed to Login,” you may have run out of connections. You should increase the open object to 2000.