Connection string is a string that contains information about a data source and means of connection to it.
It is commonly used to connect database to web application.
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;
- 26 Users Found This Useful