When using integrated security with SQL Server, the presence or absence of
a login ID determines if a user is uniquely known within SQL Server or is
instead mapped to a default account, if one exists. If no default account
and no login ID exists for a specific user, that user cannot log in.
If no login ID exists for a specific user, the following error message
appears when that login ID is used in an attempt to initiate an ODBC
connection to SQL Server:
Connection Failed
SQL State: '28000'
SQL Server Error: 4002
[Microsoft][ODBC SQL Server Driver][SQL Server] Login Failed
This article describes how to add a valid user SQL Server login ID from
within Visual FoxPro.