For SQL Server connections, you can specify the user account and password in three different locations: in the ConnectionString property, in the Properties collection of the Connection object, or as parameters for the Open method. If you provide this information as parameters for the Open method, the parameter values will override any User ID or Password settings in the ConnectionString or Properties collection. If you do not supply any parameters for the Open method, the ConnectionString arguments will override the settings in the Properties collection.