title: How to connect to MSSQL from Pentaho?
body: <p>I am trying to connect Pentaho to my local MSSQL server.
  I start Microsoft SQL Server Management Studio and I am promted with this window and then just click Connect:</p>
  <p><a href="https://i.stack.imgur.com/KpIKB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KpIKB.png" alt="enter image description here" /></a></p>
  <p>I am using Java 8 Update 261 and Pentaho 7.1. I have downloaded MSSQL JDBC driver from following link:
  <a href="https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15</a></p>
  <p>and put <code>mssql-jdbc-8.4.1.jre8.jar</code> into <code>pdi-ce-7.1.0.0-12\data-integration\lib</code> folder. Also I have coppied file <code>mssql-jdbc_auth-8.4.1.x64.dll</code> into <code>C:\Program Files\Java\jre1.8.0_261\bin</code>...</p>
  <p>Now when I start Pentaho via Spoon.bat file, and try to add MSSQL connection, I get errors, furthermore I have no idea what I am supposed to enter into fields:</p>
  <p>HOSTNAME:  ?
  DATABASE NAME: (name of database is PROFIT)
  INSTANCE NAME: ?
  PORT: 1433
  USERNAME: ?
  PASSWORD: ?</p>
  <p><a href="https://i.stack.imgur.com/mrk6e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mrk6e.png" alt="enter image description here" /></a></p>
  <p>From the picture you can see what I have entered. I also checked <code>Use Integrated Security</code> box.
  I get following error:</p>
  <pre><code>Error connecting to database: (using class com.microsoft.sqlserver.jdbc.SQLServerDriver)
  The TCP/IP connection to the host DESKTOP-CS70NHL, port 1433 has failed. Error: &quot;Socket operation on nonsocket: configureBlocking. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.&quot;.
  </code></pre>