Why do we need SQL server installed on the box on which we are setting up HDP for windows?

[#1]

While installing HDP on Windows Server2012 R2, it gives me the following error:

java.lang.Exception: Could not connect to the database: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host MDNJAPP02, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

[#2 · Accepted solution]

you need a database for Hive, if it can't find a database it will complain @rohit vishwakarma here's documentation for minimum software requirements.

[#3]

Thanks @Artem Ervits.

Which version of SQL do I need?

[#4]

Thanks again, I missed the software requirement link. Will go through it

[#5]

@rohit vishwakarma use the very latest documentation, here's link.

[#6]

@rohit vishwakarma for HDP 2.3.4 you will need SQL 2012. Docs here.