Shulou(Shulou.com)05/31 Report--

This article is to share with you about how to connect to SQL Server in DataGrip. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article.

JetBrains DataGrip tutorial

DataGrip can cover some of the specific needs of SQL developers, such as connecting from OSX to SQL Server or even using Windows authentication. Since the launch of DataGrip, we have received a lot of comments about connecting to SQL Server. It doesn't seem to be as simple as other databases and requires a few extra steps in advance. This is a small guide that describes the major problems you may face and how to solve them.

First, make sure that the important options in the SQL Server configuration manager are configured correctly. Make sure SQL Server Browser is running:

TCP / IP connections need to be enabled:

To know which port to connect, simply click TCP / IP. In our example, it is the default port 1433.

If you eventually change anything, restart the server. In most cases, this will resolve the connection problem, your server will accept remote connections, and you are ready. If you still have problems, you may need to adjust the TCP port or enable a remote connection to the SQL Server in its settings. This tutorial will guide you through it, but we will also describe the process here. Press Alt / Cmd + 1 to invoke the database view and create a new data source using the appropriate driver. If you use the Microsoft driver, note that it supports SQL Server 2008 and later. Here, we assume that it is the jTds driver.

If you do not have a driver, click the link to download.

Then enter the hostname, instance name, and credentials. Keep in mind that DataGrip provides the completion of the host, instance, and database names (Ctrl / Cmd + Space), but the database name is optional. For those of you who are used to the SSMS interface, let's compare the connection window.

If the port number conflicts with the instance name, the instance name takes precedence over the port number in the jTds driver, and the opposite occurs in the Microsoft driver. To avoid confusion, simply delete the port number. If you strongly want to specify the port number, click the automatic Settings button (to the right of the instance field) to set the port number automatically. Keep in mind, however, that if you restart the server, you can change the port number.

If you need to use Windows authentication, only the Microsoft driver is allowed to do so.

Another way to connect to the server using Windows authentication is to use domain authentication with the jTds driver, which allows you to connect from any other computer. It is worth noting that it applies to any operating system. To do this, go to the Advanced tab of the data source properties, set USENTLMV2 to true, and specify the domain name in the DOMAIN field.

The above is how to connect to SQL Server in DataGrip. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.