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:
  • Content Manager End User components
  • Content Manager Author components
  • Content Manager Database

Settings:

WhatProtocolPortDirection
SQLServerTCP1433IN/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.