question Re: Why do we need SQL server installed on the box on which we are setting up HDP for windows? in Archives of Support Questions (Read Only)

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

rvishwakarma — Fri, 16 Sep 2022 09:58:37 GMT

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.".

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

aervits — Wed, 20 Jan 2016 22:12:22 GMT

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.

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

rvishwakarma — Wed, 20 Jan 2016 22:19:40 GMT

Thanks @Artem Ervits.

Which version of SQL do I need?

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

rvishwakarma — Wed, 20 Jan 2016 22:21:16 GMT

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

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

aervits — Wed, 20 Jan 2016 22:21:47 GMT

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

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

aervits — Wed, 20 Jan 2016 22:23:30 GMT

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