Create a Microsoft SQL Server data source

Create a Microsoft SQL Server data source

Required settings

Microsoft SQL Server accepts TCP/IP connections on a dedicated port. By default, it is port and it is closed by the Microsoft Windows Firewall. When connecting via port, make sure that the port that you use is not closed by the Firewall.

If the SQL Server Browser is turned on, TCP/IP connection can also be established using the Microsoft SQL Server instance name.

Enable and configure the TCP/IP connection

Follow the official instructions to enable the protocol, check and assign a port number. Verify that other running applications do not use the same port.

Name of the Microsoft SQL Server instance is MSSQLSERVER. By default, the port is .

If you changed any settings, restart the server. For most situations, the restart resolves connection problems.