Hi,
I'm using sdac 3.00 for cppbuilder 6. I'm trying to connect to SQL server 2000 from a XP SP2 box and here is what happens:
If I use auServer with a correct username and password it will ONLY work if the SQL server machine also has an account in its local users that matches the client computers current logon.
Both the auServer (SQL authenticiation) name and password MUST be correct AND the client computers Windows username/passwork MUST be present on the SQL machine. Any idea why the windows user must exist? If I go in and disable the windows user on the SQL Server, I can no longer logon to sql using auServer even with the right name/pass...
If I try auWindows it won't work at all.
Thanks,
SA Dev
Authenticiation problems...
> If I go in and disable the windows user on the SQL Server, I can no longer
> logon to sql using auServer even with the right name/pass...
Another users have never informed us about similar problems.
Could you establish a connection from QueryAnalyzer at the last case?
> If I try auWindows it won't work at all.
To work in this mode you have to make settings at the server. for details please refer to documentation for MS SQL.
> logon to sql using auServer even with the right name/pass...
Another users have never informed us about similar problems.
Could you establish a connection from QueryAnalyzer at the last case?
> If I try auWindows it won't work at all.
To work in this mode you have to make settings at the server. for details please refer to documentation for MS SQL.