MS SQL why did the query time out?

Question

PowerShell

Hello comrades!
I took care of writing a Power Shell script to backup several databases from MS SQL.

$Server = "localhost"
$BaseName = "master"
$BaseLogin = "user"
$BasePassw = "password"
$connection = New-Object -com "ADODB.Connection"
$ConnectionString = "Provider=SQLOLEDB.1;
                     Data Source=$Server;
                     Initial Catalog=$BaseName;
                     User ID=$BaseLogin;
                     Password=$BasePassw;
         Connection Timeout=0;"
$connection.Open($ConnectionString)
$connection.Execute("BACKUP DATABASE [db_name] TO DISK = 'd:\bak\db_name.sql' WITH INIT, NOFORMAT, SKIP, NOUNLOAD")
$connection.Close()

This is, of course, stripped-down code and returns an error: Exception calling "Execute" with "1" arguments: "Request timed out".
At the same time, if you run a query from Management Studio, then the query is executed without errors. The execution time is just over 2 minutes.
After digging around the Internet, I found advice to play around with the Connection Timeout in the connection string. They promise that with a value of "0" the timeout error should disappear. It was not there ...
Tell me, plz, how to overcome this trouble?

Answer 1

Ugh, infection!
Lost so much time ... The
Connection Timeout=600;
zero value of the timeout, apparently, tightens the default value.