question Re: How to set up SQL Server Settings? in Support Questions

How to set up SQL Server Settings?

teruterubohz — Fri, 16 Sep 2022 10:03:05 GMT

Hi,

I manage to set up SQL Server 2012 for HDP2.3.4 on Windows Server 2012.

I set this in the same way as the manual "Hortonworks Data Platform -Installing HDP on Windows".

"1.2.4.(Optional)Microsoft SQL Server for Hive and Oozie Database Instances" says below.

1st.Make hive and oozie DB.

2nd.Make accounts for hive and oozie DB with sysadmin.

3rd.Set policy to user SQL and Windows authentication for SQL.

But installation fails.

Error logs say "Can't access "oozie" database from this login. Login fails".

How do I set MS SQL Server 2012 for HDP?

Re: How to set up SQL Server Settings?

nsabharwal — Tue, 09 Feb 2016 11:31:44 GMT

@teru mat

You can setup your own sql server and leverage that for the backend. like https://msdn.microsoft.com/en-us/library/ms143219.aspx

Re: How to set up SQL Server Settings?

nsabharwal — Tue, 09 Feb 2016 11:32:20 GMT

See this http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4-Win/bk_HDP_Install_Win/content/ref-e57b29d7-37b6-4b5b-bf76-ba07711e49ce.1.html

Re: How to set up SQL Server Settings?

SQLShaw — Tue, 09 Feb 2016 11:52:10 GMT

@teru mat make sure you create a SQL server user in SQL Server which matches the user specified in the HDP install. This will need to be a native SQL user. You can't use Windows authentication since HDP on Windows does not currently support Kerberos.

Re: How to set up SQL Server Settings?

teruterubohz — Wed, 10 Feb 2016 09:09:43 GMT

Thank you for your comment.

Your advice says that I had to make user "Hadoop" , this user is set in HDP install , in SQL server on Windows Server 2012.

And I give authentication this user "Hadoop" for hive and oozie database.

Is it right?

I tried that, but it failed...

Can you show me more details?

Re: How to set up SQL Server Settings?

nsabharwal — Wed, 10 Feb 2016 09:14:27 GMT

@teru mat Please see this document

Re: How to set up SQL Server Settings?

teruterubohz — Wed, 10 Feb 2016 09:15:00 GMT

Thank you for your comment.

I setup SQL server 2012 on my windows and did that same as this manual,

http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4-Win/bk_HDP_Install_Win/content/ref-e57b29d7-37b6-4b5b-bf76-ba07711e49ce.1.html.

But there aren't details on this manual.

I am at a loss...

Re: How to set up SQL Server Settings?

nsabharwal — Wed, 10 Feb 2016 09:17:37 GMT

@teru mat What details are you looking for?

See this manual http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4-Win/bk_QuickStart_HDPWin/content/inst_HDPWin.html

Re: How to set up SQL Server Settings?

teruterubohz — Tue, 16 Feb 2016 09:42:06 GMT

I got it !

At last I could install HDP2.3.4.0 with MSSQL 2012.

Point.

After creating users and passwords, "hive_user" and "oozie_user" and password "hive_password" and "oozie_password", on MSSQL,

I had login to MSSQL via new users ,"hive_user" and "oozie_user", to determine these users.

Then I could install HDP2.3.4.0 with MSSQL 2012.

Thank you for your advice, Scott Shaw and Neeraj Sabharwal.

By the way,

The reason that I decided to use MSSQL is that Derby is not stable with HDP on Windows Server 2012.

If Derby is unstable, Oozie service is not stable.

Are there same phenomena like this?