Thank you! You are correct. That works. I thought I'd tried it without the user name and password but guess not.
Thanks a ton,
Randy
>You don't need user name and password for Windows authentication. Try
lnHandle = Sqlstringconnect("driver=SQL Server" + ;
> ";server=MySQLServer" + ;
> ";database=MyDatabase" + ;
> ";app=MyApp(3.2.0)")
>
>>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