Data Link Properties Setup for MS SQL Server 2012

  • If the SQL Database using MS SQL Server 2012, select the OLE DB Provider with the "SQL Server Native Client 11". The click Next or Select the "Connection" tab.

  • On the "Connection" tab :
    • Enter the server name with the MS SQL Server IP Address
    • Enter Log on information, select between two choices
      • Use Windows NT Integrated Security
      • Use a spesific username and password
        • There are some Microsoft "intended bug" in the SQL Server Native Client  , that the "Allow Saving Password" is couldn't be enabled.
        • The connection String should be edited manually after the connection string is created, set the Persis Security Info to True and add the Password field, in this example the Password is, test123 : 
          • The original Connection String generated by wizard is :
            • Provider=SQLNCLI11.1;Persist Security Info=False;User ID=smsgee;Initial Catalog=SMSGEE44;Data Source=192.168.1.10;Initial File Name="";Server SPN=""
          • Edit to : 
            • Provider=SQLNCLI11.1;Persist Security Info=True;User ID=smsgee;Initial Catalog=SMSGEE44;Data Source=192.168.1.10;Initial File Name="";Server SPN="";Password=test123
    • Select the Database

  • Click OK to apply changes of the Connection String