SEARCH
Knowledgebase
Connection strings for SQL Server
Posted by on 04 October 2018 10:32 AM

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;

 

For more information, please visit https://www.connectionstrings.com/sql-server/

(0 vote(s))
Helpful
Not helpful
Comments (0)
Copyright © 1998 - 2021 Shinjiru International Inc. All Rights Reserved.