The problem with slow connection opening may be caused by using the outdated Microsoft OLE DB Provider for SQL Server (Provider=SQLOLEDB.1).

In this case, switching to Microsoft OLE DB Driver for SQL Server (Provider=MSOLEDBSQL.1) should help.