We are connecting to SQL Server using SQL Server authentication using the following code:
lnHandle = Sqlstringconnect("driver=SQL Server" + ;
";server=MySQLServer" + ;
";uid=username" + ;
";pwd=password" + ;
";database=MyDatabase" + ;
";app=MyApp(3.2.0)")
We need to move to Windows authentication where database users belong to a security group in Windows Active Directory. This Active Directory user group is then added as a login to SQL Server.
With this model the user fails to authenticate using the above string connect, as it seems that SQL is looking for the exact user login. The user can authenticate through a DSN or a CursorAdaptor but we do not use either.
Any help would be appreciated.
Randy Barnett
Ascension Capital Group
Arlington, Texas USA