I have the following connection-string to connect to local MS-SQL Server version Microsoft SQL Server 2019 (RTM-GDR) (KB5021125) - 15.0.2101.7 (X64)

Data Source=<PC name>\\<instance name>;Initial Catalog=<db name>;User Id=sa;Password=<password>;

It works very well with my C# code.

I also activated both Windows login and SA login

I would like to connect to that database from rust using tiberius and tokio runtime

So I did follow their documentation example code,

I checked multiple combinations of commented lines below, still cannot connect to my db

//let mut config = Config::from_ado_string("<connection string above>").expect("failed");
//let mut config = Config::new();
//config.host("<pc name here>");
//config.host("<pc ip here>");
//config.host("<pc name here>\\<instance name here>");
//config.host("localhost");
//config.host("127.0.0.1");
//config.host("0.0.0.0");
//config.port(<port, usually 1433>);
//config.instance_name("<instance name here>");
//config.database("<db name>");
//config.authentication(AuthMethod::sql_server("sa", "<password here>"));
//config.trust_cert();

let tcp = TcpStream::connect(config.get_addr()).await?;

Experience these type of errors:

Os { code: 10061, kind: ConnectionRefused, message: "No connection could be made because the target machine actively refused it." }

I cannot spot what I am missing there. Guessing that instance name confuses it, rather than directly connecting to host