Cloudera Community
teruterubohz
user rank
Explorer
My Accepted Solutions
Show All

Re: How to set up SQL Server Settings?

by Explorer in Support Questions
‎02-16-2016 01:42 AM
1 Kudo
‎02-16-2016 01:42 AM
1 Kudo
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? ... View more

Re: How to set up SQL Server Settings?

by Explorer in Support Questions
‎02-10-2016 01:15 AM
1 Kudo
‎02-10-2016 01:15 AM
1 Kudo
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... ... View more

Re: How to set up SQL Server Settings?

by Explorer in Support Questions
‎02-10-2016 01:09 AM
‎02-10-2016 01:09 AM
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? ... View more

How to set up SQL Server Settings?

by Explorer in Support Questions
‎02-09-2016 03:28 AM
2 Kudos
‎02-09-2016 03:28 AM
2 Kudos
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? ... View more
Contact Me
Online
Offline
Last Visited
‎02-16-2016 01:42 AM
Community Statistics
Member Since ‎02-09-2016 03:21 AM
Last Visited ‎02-16-2016 01:42 AM
Posts 4
Kudos received 4