Connection strings for SQL Server

Last modified: July 29, 2019
You are here:
Estimated reading time: < 1 min

Connection strings for SQL Server

However, Connection string with standard security:

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

Firstly, Alternative syntax 1:

Server=SQL_SERVER_IP,MSSQL_PORT;Database=DATABASE_NAME;User ID=DATABASE_USER;Password=DATABASE_USER_PASSWORD;Trusted_Connection=False;


Secondly, Alternative syntax 2:

Server=SQL_SERVER_IP,MSSQL_PORT;Database=DATABASE_NAME;User

id=DATABASE_USER;pwd=DATABASE_USER_PASSWORD;

 

 

Was this article helpful?
Dislike 0
Views: 49