Schema Compare times out with error "The timeout period elapsed prior to obtaining a connection f (77888)

System.InvalidOperationException
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.
Stack Trace:
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Quest.Shared.MSSQL.SQLConnOptions.GetOpenSqlConnection(ISQLConnOptions conn, Boolean defaultConnection)
at Quest.Shared.MSSQL.ScriptEngine.GetConnection()
at Quest.Shared.MSSQL.ScriptEngine.ExecuteDataAdapter(String script)
at Quest.Shared.MSSQL.Helper.SQLServerHelper.Info.GetServerVersion(IScriptEngine engine)
at Quest.Shared.MSSQL.Helper.SQLServerHelper.Info.GetServerVersion(ISQLConnOptions conn)
at Quest.Shared.MSSQL.SQLConnOptions.<.ctor>b__0()
at Quest.Shared.Memorizing.ThreadSafeObjectHolder`1.Initialize()
at Quest.Shared.Memorizing.ThreadSafeObjectHolder`1.get_Value()
at Quest.Shared.MSSQL.SQLConnOptions.get_ServerVersion()
at Quest.Shared.MSSQL.ScriptEngine.get_ServerVersion()
at Quest.Schema.MSSQL.Snapshot.Helper.CheckSupport(IScriptEngine engine, String databaseName, Version& serverVersion, Byte& compatibilityLevel)
at Quest.Schema.MSSQL.Snapshot.Loaders.SnapshotLoader.GetHeader(ScriptProcessor`1 processor, SnapshotHeaderUserProperties userHeader)
at Quest.Schema.MSSQL.Snapshot.Loaders.SnapshotLoader.Load(ICallBack callback)
at Quest.Schema.MSSQL.Snapshot.Loaders.SnapshotLoader.Run(ICallBack callback)
at Quest.Schema.MSSQL.Snapshot.SnapshotManager.CreateInstance(ICallBack callBack, ISQLConnOptions conn, SnapshotHeaderUser

WORKAROUND:

Run the Schema Compare without making an initial connection.

1. Start Toad but do not make an initial connection

2. Click on the 'Compare and sync' icons to run your compare (see screen shot SOL77888_Fig1.jpg)

 

STATUS: Waiting for fix in a future release of Toad for SQL Server.