Keyword Description:
The keywords Data Source or server or address or addr or network address identify a meaning, that is, the addresses or names of the instances of SQL Server to which you want to connect. localhost or "." Identifies the local default instance and can also take the instance specific name, IP address.
Initial Catalog or database name to which you want to connect.
Integrated Security or Trusted_Connection whether the Trust connection method is used, the recognized value is true, false, yes, no, and SSPI equivalent to true. SQL Server integrated security (also known as a trusted connection) is the safest way to connect to SQL Server because it does not expose the user identity and password in the connection string.
Trusted_connection=true;
With a trusted connection, the current Windows account credentials are about to be authenticated. Do not userid at this time, this method can not expose the logged-in user, generally connect to the local database to use.
Trusted_connection=false;
This will not take the form of a trusted connection (that is, not Windows authentication), but rather the SQL Server authentication method, which is specified in the connection word: User id=user name; Password=user Password; SQL Server verifies this user ID and password for connections, regardless of the Windows account.
The settings for both of these authentication methods (connection validation using Windows and SQL Server authentication or only Windows authentication), you can start SQL Server Enterprise Manager, and then set up in the security configuration.
Packet size of packets used to communicate with the database, with a byte unit default of 8192
Maximum number of connections allowed in the max pool Size pool. Default 100
The minimum number of connections allowed in the min pool Size pool. Default 0
pooling Pool. The default is "True"
When True, the system extracts the SqlConnection object from the pool or, if necessary, creates the object and adds it to the appropriate pool. The recognizable values are true, false, yes, and no