Press Ctrl/Cmd + P to print
or save as PDF

Connection strings for SQL Server

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?