Article ID: 159590 - View products that this article applies to.
This article was previously published under Q159590
SQL Server can be installed utilizing either Standard, Windows NT Integrated or Mixed security. The Trusted Connection is available only under Windows NT.
When creating a new DataSource to SQL Server via the ODBC dialog box in the Control Panel of a client machine, there is a radio button check box in step 2 with the label "With Windows NT authentication using the network login ID." Checking this option requests a trusted connection to SQL Server regardless of the security mode of the server. For information about the SQL Server login security mode and trusted connections, see the Microsoft SQL Server Administrator's Companion.
Once a DataSource has been created using a Trusted Connection, a connection can be created without supplying a user name and password. The user's Windows NT userid must exist on SQL Server.
To connect from Visual FoxPro via an available DataSource:
Article ID: 159590 - Last Review: June 29, 2004 - Revision: 3.2