Setting up the SQL Server Data Link Properties
When you connect to a Microsoft SQL Server database through ADO, you may need to set the following connection properties in the All tab of the Data Link Properties dialog box.
Data Link Properties dialog box
If you selected the SQL Server Native Client data provider on the Provider tab, set this property to a space character.
Persist Security Info
Set this property to True.