SQL Server connection string multiple configurations

1 Application Name (application name): The name of the application. If not specified, it has a value of. NET SqlClient data Provider.2 attachdbfilename/extended Properties (extended property)/initial file name (initial file name): The name of the primary file that can connect to the database, including the full path name. The database name must be specified with the keyword database. 3 Connect Timeout (connection timeout)/connection timeout (connection timeout): The length of time (in seconds) that a connection to the server waits before terminating, with a default value of 15. 4 Connection Lifetime (Connection Life time): When a connection is returned to the connection pool, its creation time is compared to the current time. If the time span exceeds the validity of the connection, the connection is canceled. Its default value is 0. 5 Connection Reset (Connection reset): Indicates whether a connection is reset when it is removed from the connection pool. A pseudo-effective when a connection is obtained there is no need to perform an additional server back and forth, its default value is true. 6 Current Language (currently language): The name of the SQL Server language record. 7 Data source/server (server)/address (address)/addr (address)/network address (network addresses): The name or network address of the instance of SQL Server. 8 Encrypt (encrypted): When the value is true, if the server has an authorization certificate installed, SQL Server uses SSL encryption for all data that is transferred between the client and the server. The accepted values are true (TRUE), False (pseudo), yes (yes), and no (NO). 9 Enlist (Registration): Indicates whether the connection pooling program automatically enlists the connection in the context of the current transaction in which the thread was created, with a default value of True. Ten Database /initial Catalog (initial catalog): The name of the database.  One Integrated Security (Integrated Secure)/trusted Connection (Trusted connection): Indicates whether Windows authentication is used to connect to the database. It can be set to a true, pseudo, or an SSPI with true equivalence, and its default value is pseudo.  A Max pool size (maximum connection pool capacity): The maximum number of connections allowed for a connection pool, with a default value of 100.  - min Pool Size (the minimum size of the connection pool): The minimum number of connections allowed for the connection pool, with a default value of 0.  - Network library /net (Network): A network library that is used to establish a connection to an instance of SQL Server. Supported values include: DBNMPNTW (Named Pipes), DBMSRPCN (MULTIPROTOCOL/RPC), Dbmsvinn (Banyan vines), DBMSSPXN (ipx/spx), and DBMSSOCN ( TCP/IP). The dynamic link library for the protocol must be installed to the appropriate connection with the default value of TCP/IP.  the Packet size (packet size): The amount of network packets used to communicate with the database. Its default value is 8192.  - Password (password)/pwd: the password that corresponds to the account name.  - Persist Security Info (keep security information): Used to determine if the safety information is available after the connection has been established. If the value is true, data that is sensitive to security, such as the user name and password, is available and is not available if the value is pseudo. Resetting the connection string will reconfigure the values of all connection strings, including passwords. Its default value is pseudo.  - Pooling (Pool): Determines whether connection pooling is used. If the value is true, the connection is obtained from the appropriate connection pool, or, if necessary, the connection is created and then added to the appropriate connection pool. Its default value is true.  + User ID (username): The name of the account used to log in to the database.  -Workstation ID (Workstation ID): The name of the workstation that is connected to SQL Server. The default value is the name of the local computer.