SQL server questions

SQL server can be connected to over a WAN or dail up access in many ways - it really depends on what the program has been set up to support.
If you use Named Pipes, then the current user logon can be used (SQl server has to be setup to use NT logon) and you will have little maintenance work but less security - i.e. anybody logged onto the system will get access and you ahve to do a lot of work to limit their access to the specific tables in the database.

You can set SQL server upt o use aspecific logon - the only probelm here is taht you have to setup every user in the SQL serve and maintin them.

I prefer the latter for security purposes escpecially if only some users are to have access to the the Db. You can consider generic tpye users - eg one for read only type access which would hoperfully support most of your users.

Install the SQL client software (run server setup on a workstation and will tell you that it will only install client) Then setup ODBC Connection to the DB.
You can set up the connection to use a single generic login like User: Guest
Password: Guest and everyone will access using this account (works great if the application has it's own security)or you can
set user IDs and passwords for each person individually.