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.
- Content Manager End User components
- Content Manager Author components
- Content Manager 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. Content Manager uses MSDTC for transaction actions (insert, update, delete) so NetBIOS and MSDTC firewall settings also apply.