How to set up SQL Server Settings?

[#1]

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?

[#2]

@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

[#3]

See this http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4-Win/bk_HDP_Install_Win/content/ref-e57b29d7-...

[#4]

@teru mat Please see this document

[#5]

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

But there aren't details on this manual.

I am at a loss...

[#6]

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

[#7]

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

[#8]

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?

[#9 · Accepted solution]

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?