Our users use a third party app that connects to a SQL
database on a windows 2003 member server. The app
works if the user has a windows 2003 user account local
on the server.

1. All of our user accounts are in a Novell Netware
Domain.

2. We have purchased a processor license for the SQL
server, so we have unlimited connections to SQL.

3. The user accounts that need access to the SQL Server
do not have windows 2003 local server accounts.

From our testing, it appears to be an authentication
problem.

We have tried to create only SQL user accounts, but that
also fails to authenticate.

Is there a way for our user to use the third party app
without having windows 2003 local user account or just
have only SQL user accounts to authenticate to the
database?

If SQL Server is set to Windows only authentication, the default, then
standard SQL logins will not work. You cna set SQL Server to mixed by going
to Properties - Security in Enterprise Manager.

You can also add domain users or groups to SQL Server as logins. You cannot
add local user from a client machine.

Rand
This posting is provided "as is" with no warranties and confers no rights.