Connection parameters are specific for the data provider you have chosen. In dependence of selected DBMS it is necessary to use different parameters, based on the selected DBMS specific. These parameters are used for the connection string generation. This topic describes connection parameters for SQL Client data provider.

• Server
  

  The name of the server.

• Login details
  • Use Windows Authentication
    

    Allows a network user to access the database for this connection without entering a separate User ID or password because they are obtained from the Windows NT network security process.

  • Use SQL Server Authentication
    

    Uses the specified user name and password for authentication.

    • User name
      

      The name of the user to connect.

    • Password
      

      The password for the SQL Server user acount.

• Save my password
  

  If set to true password is stored among the other connection parameters.

  Caution:
  User password will be stored in your project in an unencrypted form (as plain text).

• Database
  

  The name of the database.

Read more about connection parameters for SQL Client in MSDN.