You are currently offline, waiting for your internet to reconnect

How To Connect to SQL Server Using a Trusted Connection in VFP

This article was previously published under Q159590
SQL Server can be installed utilizing either Standard, Windows NTIntegrated or Mixed security. The Trusted Connection is available onlyunder 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 trustedconnection to SQL Server regardless of the security mode of the server. Forinformation about the SQL Server login security mode and trustedconnections, see the Microsoft SQL Server Administrator's Companion.

Once a DataSource has been created using a Trusted Connection, a connectioncan be created without supplying a user name and password. The user'sWindows NT userid must exist on SQL Server.

To connect from Visual FoxPro via an available DataSource:

  1. Create a DataSource with the Trusted Connection box checked.
  2. In a program or Command window type: x=sqlconnect("datasource name here").
  3. Print the value of x, such as "? x". If x returns a positive number, then a valid connection was established.
To connect from Visual FoxPro via an available connection from a Window NTmachine:

  1. Open up a project in Visual FoxPro.
  2. Select Connections.
  3. Select New.
  4. Choose a valid DataSource with the Trusted connection option checked.
  5. Leave the userid and password text boxes empty.
    1. Visual FoxPro 5.0 and 6 allows you to verify the connection via a command button.
  6. Select Remote Views from the project.
  7. Select New.
  8. Use the Connection created by the steps above.

Article ID: 159590 - Last Review: 06/29/2004 23:23:35 - Revision: 3.2

  • Microsoft Visual FoxPro 3.0 Standard Edition
  • Microsoft Visual FoxPro 3.0b Standard Edition
  • Microsoft Visual FoxPro 5.0 Standard Edition
  • Microsoft Visual FoxPro 6.0 Professional Edition
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • kbdatabase kbhowto kbinterop KB159590