SQL Server database connection string statement

Commonly used declarations in connection strings include:

The Server declares Data Source, Server, and Addr.

DataBase declaration Initial Catalog and DataBase.

Integrated Windows Account Security statements, such as Integrated Security and Trusted_Connection.

Use the Security Statement of the database account, such as User ID and Password.

For the account accessing the database, we usually see the string connection of ADO. NET in some references as follows:

String ConnStr = "server = localhost;

User id = sa; password = xxx; database = northwind ";

For an account integrated with Windows security, the connection string is generally written as follows:

String ConnStr = "server = localhost;

Integrated security = sspi; database = northwind ";

Or string ConnStr = "server = localhost;

Trusted_connection = yes; database = northwind ";

Using Windows integrated security verification has many advantages in accessing the database: higher security, faster access, less security architecture re-design, hard-coded connection strings, etc, it is worth using.