Groups | Blog | Home
all groups > sql server clients > may 2004 >

sql server clients : SQL Login problem


Keith Mace
5/17/2004 10:08:20 PM
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?
Invotion
5/18/2004 8:36:19 AM
It sounds like the app is set to impersonate whoever is
currently using it. You would have to change that part
of the app to force users to enter their sql login and
password in order to get around the need for windows
authentication.

Sincerely,
Invotion Engineering Team
Advanced Microsoft Hosting Solutions
http://www.Invotion.com

[quoted text, click to view]
AddThis Social Bookmark Button