Connection strings for SQL Server

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;

  • 0 A felhasználók hasznosnak találták ezt
Hasznosnak találta ezt a választ?

Kapcsolódó cikkek

SolidCP & MSPControl: Create MS SQL database

Please follow the steps below to create your MSSQL Server Database in control panel. * Please...

SolidCP & MSPControl: How to backup MSSQL database via control panel

You can backup the entire MSSQL database from hosting control panel.Please follow the steps below...

How to connect to MSSQL database using SQL Server Management Studio?

To manage your MS SQL database using SQL Server Management Studio.SQL Server Management Studio...

How to connect to older version MS SQL using Enterprise Manager?

To connect to older version of MS SQL database (such as MS SQL 2000), you can use Enterprise...

SolidCP & MSPControl: How to restore MSSQL database via control panel

You can restore the entire MSSQL database from the web hosting control panel.Please follow the...