Connecting to SQL Server using non domain account

How can I connect to SQL Server 2005 without having a domain account and through a MS Access front end that is on the main server
and shared between 20 different users? Some of the users have domain accounts 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 through a MS Access front end that is on the main server
>and shared between 20 different users? Some of the users have domain accounts 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.