2 Replies Latest reply on Jul 24, 2014 5:08 PM by 965945

    kerberos authentication for Oracle’s MS SQL Server Driver (Type 4)

    965945

      HI,

       

      I need to create the connection pool to SQL Server (using an AD service account) from WebLogic 10.3.6 using Windows Active Directory Kerberos authentication. Can someone please provide me steps todo this.

       

       

      Thanks,

      Shreya

        • 1. Re: kerberos authentication for Oracle’s MS SQL Server Driver (Type 4)
          Puneeth-Oracle

          Have a look at the following link :

           

          http://stackoverflow.com/questions/24395162/how-to-connect-to-sql-server-from-weblogic-using-windows-ad-kerberos-authenticat

           

          How To Configure OBIEE 11g To Authenticate Using a Database Identity Store (SQL Authenticator) (Doc ID 1338007.1)

          • 2. Re: kerberos authentication for Oracle’s MS SQL Server Driver (Type 4)
            965945

            Hi,

             

            Followed steps under How to connect to SQL Server from WebLogic using Windows AD Kerberos Authentication? - Stack Overflow and getting this error when I create datasource using weblogic console:

             

            http://stackoverflow.com/questions/24395162/how-to-connect-to-sql-server-from-weblogic-using-windows-ad-kerberos-authenticat

             

            ####<Jul 24, 2014 12:31:37 PM EDT> <Error> <Console> <server> <Dpqrs_admin> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <weblogic> <> <> <1406219497118> <BEA-240003> <Console encountered the following error java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]A username was not specified and the driver could not establish a connection using Kerberos (type 4) integrated security: No CallbackHandler available to garner authentication information from the user

                           at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)

                           at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)

                           at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)

                           at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)

                           at weblogic.jdbc.sqlserver.tds.ddc.<init>(Unknown Source)

                           at weblogic.jdbc.sqlserver.SQLServerImplConnection.f(Unknown Source)

                           at weblogic.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)

                           at weblogic.jdbc.sqlserverbase.BaseConnection.k(Unknown Source)

                           at weblogic.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)

                           at weblogic.jdbc.sqlserverbase.BaseConnection.a(Unknown Source)

                           at weblogic.jdbc.sqlserverbase.BaseDriver.connect(Unknown Source)

                           at weblogic.jdbc.common.internal.DataSourceUtil.testConnection(DataSourceUtil.java:298)

                           at com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:734)

                           at com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:474)

                           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                           at java.lang.reflect.Method.invoke(Method.java:606)

                           at org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:870)

                           at org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)

                           at org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)

                           at org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)

                           at org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)

                           at org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52)

                           at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)

                           at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)

                           at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)

                           at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors$WrapActionInterceptorChain.continueChain(ActionInterceptors.java:64)

                           at org.apache.beehive.netui.pageflow.interceptor.action.ActionInterceptor.wrapAction(ActionInterceptor.java:184)

                           at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors$WrapActionInterceptorChain.invoke(ActionInterceptors.java:50)

                           at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors$WrapActionInterceptorChain.continueChain(ActionInterceptors.java:58)

                           at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:87)

                           at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2116)

                           at com.bea.console.internal.ConsolePageFlowRequestProcessor.processActionPerform(ConsolePageFlowRequestProcessor.java:261)

                           at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)

                           at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:556)

                           at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:853)

                           at org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:631)

                           at org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:158)

                           at com.bea.console.internal.ConsoleActionServlet.process(ConsoleActionServlet.java:262)

                           at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)

                           at com.bea.console.internal.ConsoleActionServlet.doGet(ConsoleActionServlet.java:134)

                           at org.apache.beehive.netui.pageflow.PageFlowUtils.strutsLookup(PageFlowUtils.java:1199)

                           at com.bea.portlet.adapter.scopedcontent.ScopedContentCommonSupport.executeAction(ScopedContentCommonSupport.java:686)

                           at com.bea.portlet.adapter.scopedcontent.ScopedContentCommonSupport.processActionInternal(ScopedContentCommonSupport.java:142)

                           at com.bea.portlet.adapter.scopedcontent.PageFlowStubImpl.processAction(PageFlowStubImpl.java:106)

                           at com.bea.portlet.adapter.NetuiActionHandler.raiseScopedAction(NetuiActionHandler.java:111)

                           at com.bea.netuix.servlets.controls.content.NetuiContent.raiseScopedAction(NetuiContent.java:181)

                           at com.bea.netuix.servlets.controls.content.NetuiContent.raiseScopedAction(NetuiContent.java:167)

                           at com.bea.netuix.servlets.controls.content.NetuiContent.handlePostbackData(NetuiContent.java:225)

                           at com.bea.netuix.nf.ControlLifecycle$2.visit(ControlLifecycle.java:180)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:324)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walkRecursive(ControlTreeWalker.java:334)

                           at com.bea.netuix.nf.ControlTreeWalker.walk(ControlTreeWalker.java:130)

                           at com.bea.netuix.nf.Lifecycle.processLifecycles(Lifecycle.java:395)

                           at com.bea.netuix.nf.Lifecycle.processLifecycles(Lifecycle.java:361)

                           at com.bea.netuix.nf.Lifecycle.processLifecycles(Lifecycle.java:352)

                           at com.bea.netuix.nf.Lifecycle.runInbound(Lifecycle.java:184)

                           at com.bea.netuix.nf.Lifecycle.run(Lifecycle.java:159)

                           at com.bea.netuix.servlets.manager.UIServlet.runLifecycle(UIServlet.java:388)

                           at com.bea.netuix.servlets.manager.UIServlet.doPost(UIServlet.java:258)

                           at com.bea.netuix.servlets.manager.UIServlet.service(UIServlet.java:199)

                           at com.bea.netuix.servlets.manager.SingleFileServlet.service(SingleFileServlet.java:251)

                           at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

                           at com.bea.console.utils.MBeanUtilsInitSingleFileServlet.service(MBeanUtilsInitSingleFileServlet.java:64)

                           at weblogic.servlet.AsyncInitServlet.service(AsyncInitServlet.java:130)

                           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

                           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

                           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

                           at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

                           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)

                           at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

                           at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)

                           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)

                           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)

                           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

                           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

                           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)

                           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)

                           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)

                           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

                           at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

             

             

            Thanks,