How to connect to MS SQL Server Express in JetBrains DataGrip?
<p>I'm trying to set up new tool from <code>JetBrains</code>: <code>DataGrip</code> to work with my local install of <code>MS SQL Server 2014 Express</code>. I spent some time trying to "convert" ms connection string to jdbc, but no luck. I can connect using <code>MS SQL Server 2014 management Studio</code>.</p>

<p>So here is my connection string:</p>

<pre><code>"Data Source=MyPCName\MySQLInstanceName;Initial Catalog=MyDataBaseNameA3D;Integrated Security=True;"
</code></pre>

<p>My best guess was based on msdn example: </p>

<pre><code>jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
</code></pre>

<p><a href="https://msdn.microsoft.com/en-us/library/ms378428%28v=sql.110%29.aspx?f=255&amp;MSPPError=-2147217396" rel="noreferrer">MSDN: Connecting to SQL Server with the JDBC Driver. Building the Connection URL</a></p>

<pre><code>jdbc:sqlserver://MyPCName\MySQLInstanceName:1433;databaseName=MyDataBaseNameA3D;integratedSecurity=true;
</code></pre>

<p>Has anyone resolved such issue and maybe can walk me through setup steps? </p>

<p>Otherwise I'm just going to drop this tool. I've wasted enough time on something that should be very simplistic.</p>