Shulou(Shulou.com)06/01 Report--

DataGrip supports almost all major relational database products, such as DB2, Derby, H2, MySQL, Oracle, PostgreSQL, SQL Server, Sqllite, and Sybase, and provides an easy-to-use interface that allows you to execute queries in different schemas. In this article, we introduce how to connect DataGrip to MS SQL Server.

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.

Then enter Windows credentials in the user / password field, and then click Test connection. If you want to check the specific database or schema displayed in the database view, go to the Schema tab in the data source properties:

If you are already using DataGrip 2016.2 EAP, use More Schemas in the database view.:

All selected databases are displayed in the database view. This is what it looks like in SQL Server Management Studio:

Here is what DataGrip looks like:

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.