Connection strings for SQL Server

Last modified: February 17, 2020
You are here:
Estimated reading time: < 1 min
Connection string with standard security:

Data Source=SQL_SERVER_IP,MSSQL_PORT;Initial Catalog=DATABASE_NAME;User .And next, Id=DATABASE_USER;Password=DATABASE_USER_PASSWORD;

Alternative syntax 1:

Firstly, Server=SQL_SERVER_IP,MSSQL_PORT;Database=DATABASE_NAME;User . And then, ID=DATABASE_USER;Password=DATABASE_USER_PASSWORD;Trusted_Connection=False;


Alternative syntax 2:

Secondly, Server=SQL_SERVER_IP,MSSQL_PORT;Database=DATABASE_NAME;uid=DATABASE_USER;pwd=DATABASE_USER_PASSWORD;

Was this article helpful?
Dislike 0
Views: 21