To connect to Microsoft SQL Server, we need to know some information about it:
The name of the server computer that is running the RDBMS
The name of the database
Security information, such as username and password, or if we should pass the currently logged-on user's credentials automatically
We specify this information in a connection string. For backward compatibility, there are multiple possible keywords we can use. Here are some examples:
Data Source or server or addr: This is the name of the server (and an optional instance).
Initial Catalog or database: This is the name of the database.
Integrated Security or trusted_connection: This keyword is set to true or SSPI to pass the thread's current user credentials.