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;
User id=DATABASE_USER;
pwd=DATABASE_USER_PASSWORD;
Check out next article on How to access MS SQL 2000?