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.