Set Up SQL Server Data Link Properties
If you connect to a Microsoft SQL Server database through ADO, check the following properties in the All tab of the Data Link Properties dialog box (screenshot below).
•Integrated Security: If SQL Server Native Client is the data provider on the Provider tab, set this property to a space character.
•Persist Security Info: Set this property to True.
