2 Replies Latest reply: Nov 8, 2012 5:40 AM by BMK RSS

    How to connect to MS Sql from ODI using windows authentication ?

    BMK
      Hi all,

      I have given the server name,port,windows user,pswd details in topology manager to connect to ms sql.

      I am using the MSSQL driver which comes with ODI by default.

      I am getting the following error.

      java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Login failed for user 'XXXXXXX'.
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
           at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1118)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:419)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.localConnect(SnpsDialogTestConnet.java:859)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.jButtonTest_ActionPerformed(SnpsDialogTestConnet.java:806)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.connEtoC1(SnpsDialogTestConnet.java:165)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$1(SnpsDialogTestConnet.java:161)
           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$IvjEventHandler.actionPerformed(SnpsDialogTestConnet.java:111)
           at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
           at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
           at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
           at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
           at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
           at java.awt.Component.processMouseEvent(Component.java:6290)
           at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
           at java.awt.Component.processEvent(Component.java:6055)
           
      etc...


      can any one please help me on this?