Microsoft SQL Server
Ports and protocols used by Microsoft SQL Server database engine (SQLServer).
Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) which is used by Microsoft.
Used by:
- SDL LiveContent Architect End User components
- SDL LiveContent Architect Author components
- SDL LiveContent Architect Database
Settings:
| What | Protocol | Port | Direction |
|---|---|---|---|
| SQLServer | TCP | 1433 | IN/OUT |
Microsoft SQL Server by default uses TCP 1433 but this can be changed using SQLServer Enterprise manager or the Database Management Studio. SDL LiveContent Architect uses MSDTC for transaction actions (insert, update, delete) so NetBIOS and MSDTC firewall settings also apply.