Yes, you'd create a group on the SQL Server with appropriate rights and then add the users into that group. Then the user will get authenticated automatically based on username/password/groupmembership and the UID/PWD fields in the connection string are superfluous.
_________________________
There are two types of vessels, submarines and targets.