Connecting to SQL Server using non domain account

How can I connect to SQL Server 2005 without having a domain account and thr
ough a MS Access front end that is on the main server
and shared between 20 different users? Some of the users have domain account
s and they can use the database, but those that do not
have domain accounts cannot connect. Is there a way to get this working?
Cheers,
Max.Do you have a database administrator for the SQL Server? Someone will
need to create SQL logins and grant permissions in the database.
--Mary
On Thu, 11 Jan 2007 15:14:36 -0500, "Max" <maxy_100@.yahoo.com> wrote:

>How can I connect to SQL Server 2005 without having a domain account and th
rough a MS Access front end that is on the main server
>and shared between 20 different users? Some of the users have domain accoun
ts and they can use the database, but those that do not
>have domain accounts cannot connect. Is there a way to get this working?
>Cheers,
>Max.