Yes, the best way is to use VFP SQLConnect function, it allows you to pass UID and PSW to make connection. There is yet one thing, I think you can't allow all users be logged in with administrative privileges ('sa' user).

Alex