instaling IntelliJ IDEA Ultimate 2023.1.3

Note that the Use Windows domain authentication checkbox is available only on Windows. The following section describes configuration of IntelliJ IDEA on Windows, macOS, and Linux. Connect to Microsoft SQL Server with IntelliJ IDEA For most situations, the restart resolves connection problems. If you changed any settings, restart the server. Name of the Microsoft SQL Server instance is MSSQLSERVER.

Verify that other running applications do not use the same port. Enable and configure the TCP/IP connectionįollow the official instructions to enable the protocol, check and assign a port number. If the SQL Server Browser is turned on, TCP/IP connection can also be established using the Microsoft SQL Server instance name. When connecting via port, make sure that the port that you use is not closed by the Firewall. By default, it is port 1433 and it is closed by the Microsoft Windows Firewall. Microsoft SQL Server accepts TCP/IP connections on a dedicated port. If you already have Microsoft SQL Server installed and configured, consider jumping to the section that describes a creation of a database connection in IntelliJ IDEA. This topic gives you an example of how you can configure Microsoft SQL Server and create a connection to it from IntelliJ IDEA. To download Microsoft SQL Server database software, refer to the official software downloads.

Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name.įor full information about Microsoft SQL Server, refer to the official documentation. Press Control+Alt+S to open the IDE settings and then select Plugins. The Database Tools and SQL plugin is available only in IntelliJ IDEA Ultimate. If the relevant features aren't available, make sure that you didn't disable the plugin.

This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in IntelliJ IDEA by default.

Instaling IntelliJ IDEA Ultimate 2023.1.3