The SQLOLEDB provider has a number of optional parameters beyond those the Connection object exposes. When Integrated Security is set to SSPI (Security Support Provider Interface), the authentication service for Microsoft NT Integrated Security, SQL server uses the trusted connection to obtain a username. If we choose SQL authentication, we provide a username and password with the User Id and Password parameters.