Hi James, Did you figure out why oozie would not connect to MSSQL 2012? Thanks Dave ...
Did you figure out why oozie would not connect to MSSQL 2012?
I have installed HDP on Windows 2012 and am using a separate MS SQL Server 2012 server to host the Hive_Metastore and Oozie_Metastore. Oozie seems to have some problems and keeps throwing SQL exceptions that the login is denied. the errors in the below. I have checked the user accounts and passwords and it is correct. I have concluded its not a connection issue as the Hive_metastore has been created and is working. any help please. this is the last component I have to getting my cluster up and running.
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'oozie'.