Optional collection of _mssql in SQL Server database connection string

Source: Internet
Author: User
Tags connection pooling current time connection reset
Application name (application name): the names of the applications. If it is not specified, its value is. NET SqlClient data Provider.

Attachdbfilename/extended Properties (extended property)/initial file name (initial file name): The name of the primary files that can connect to the database, including the full path name. The database name must be specified with a keyword database.

Connect Timeout (Connection timeout)/connection Timeout (Connection timeout): The length of time (in seconds) that a connection to the server waits before terminating, the default value is 15.

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 lifetime of the connection, the connection is 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-effective when you get a connection, you don't have to do an extra server back and forth, and the default value is true.

Current Language: Name of the SQL Server language record.

Data source/server (server)/address (address)/addr (address)/network Addressing (network address): The name or network address of an instance of SQL Server.

Encrypt (encryption): When the value is true, SQL Server uses SSL encryption for all data transferred between the client and the server if the server has an authorization certificate installed. The accepted value has true (true), False (false), yes (yes), and no (NO).

Enlist (Registration): Indicates whether the connection pooling program automatically enlists the connection in the current transaction context of the creation thread, and its default value is true.

Database (database)/initial Catalog (initial catalog): The name of the databases.

Integrated security (Integrated Secure)/trusted Connection (Trusted connection): Indicates whether Windows authentication is used to connect to the database. It can be set to true, pseudo, or SSPI with true equivalence, and its default value is pseudo.

Max Pool Size (maximum connection pool capacity): The maximum number of connections allowed by the connection pool, with a default value of 100.

Min Pool Size (minimum capacity of the connection pool): The minimum number of connections allowed by the connection pool, with a default value of 0.

Network library (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, and the default is TCP/IP.

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 secure information): Used to determine if security information is available once the connection is established. If the value is true, the data that is sensitive to security, such as user name and password, is available, and if the value is pseudo, it is not available. Resetting the connection string will reconfigure the values of all connection strings, including passwords. The 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. The default value is true.

User ID (User ID): 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.
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.