. Net SQL connection string details

• Application name(ApplicationProgramName ):The name of the application. If it is not specified, its value is. Net sqlclient data provider ).
• Attachdbfilename/Extended Properties(Extended attributes )/Initial file name(Initial file name ):Name of the main file that can be connected to the database, including the full path name. The database name must be specified with the keyword database.
• Connect timeout(Connection timeout )/Connection timeout(Connection timeout ):The length (in seconds) of a connection to the server before termination. The default value is 15.
• Connection lifetime(Connection survival time ):When a connection is returned to the connection pool, its creation time is compared with the current time. If the time span exceeds the validity period of the connection, the connection will be canceled. The default value is 0.
• Connection Reset(Connection Reset ):Indicates whether a connection is reset when it is removed from the connection pool. A pseudo-valid server does not need to run back and forth after obtaining a connection. The default value is true.
• Current Language(Current language ):The name of the SQL Server language record.
• Data Source(Data Source )/Server(Server )/Address(Address )/ADDR(Address )/Network Address(Network address ):The name or network address of the SQL server instance.
• Encrypt(Encrypted ):When the value is true, if an authorization certificate is installed on the server, SQL server uses SSL encryption for all data transmitted between the client and the server. The accepted values include true, false, Yes, and no ).
• Enlist(Registration ):Indicates whether the connection pool program automatically registers the connection in the current transaction context of the Creation thread. The default value is true.
• Database(Database )/Initial catalog(Initial cataloguing): Name of the database.
• Integrated Security(Integrated Security )/Trusted connection(Trusted connection ):Indicates whether Windows authentication is used to connect to the database. It can be set to "true", "false", or "true-to-peer" sspi. Its default value is "false.
• Max pool size(Maximum capacity of the Connection Pool ):The maximum number of connections allowed by the connection pool. The default value is 100.
• Min pool size(Minimum capacity of the Connection Pool ):The minimum value of the number of connections allowed by the connection pool. The default value is 0.
• Network Library(Network library )/Net(Network ):The network library used to establish a connection to an SQL server instance. Supported values include dbnmpntw (Named Pipes), dbmsrpcn (Multiprotocol/RPC), dbmsvinn (Banyan Vines), dbmsspxn (IPX/SPX), and dbmssocn (TCP/IP ). The dynamic Connection Library of the Protocol must be installed to an appropriate connection. The default value is TCP/IP.
• Packet Size(Packet size ):The size of the network packet used to communicate with the database. The default value is 8192.
• Password(Password )/PWD:The password corresponding to the account name.
• Persist Security info(Keep security information ):Used to determine whether security information is available after a connection is established. If the value is true, sensitive data such as the user name and password is available, and false data is unavailable. Resetting the connection string will reconfigure the values of all connection strings, including passwords. The default value is false.
• Pooling(Pool ):Determine whether to use the connection pool. If the value is true, the connection will be obtained from the appropriate connection pool, or, if necessary, the connection will be created and then added to the appropriate connection pool. The default value is true.
• User ID(UserID):The account name used to log on to the database.
• Workstation ID(WorkstationID):The name of the workstation that connects to SQL Server. The default value is the name of the local computer.