So you are connecting to a SQL database which contains user account information or some data tied to the username?
I am assuming you used the service account in your connection when designing your form? Does this work?
I have not used a service account but my assumption would be that it would encase the authentication into the data connection for the form and all users would use the SA as long is it was setup in designer.