Knowledge Base

Connection strings for SQL Server

Connection string with standard security:
Data Source=SQL_SERVER_IP,MSSQL_PORT;Initial Catalog=DATABASE_NAME;User Id=DATABASE_USER;Password=DATABASE_USER_PASSWORD;

Alternative syntax 1:
Server=SQL_SERVER_IP,MSSQL_PORT;Database=DATABASE_NAME;User ID=DATABASE_USER;Password=DATABASE_USER_PASSWORD;Trusted_Connection=False;

Alternative syntax 2:
Server=SQL_SERVER_IP,MSSQL_PORT;Database=DATABASE_NAME;uid=DATABASE_USER;pwd=DATABASE_USER_PASSWORD;