4 Replies Latest reply: Sep 24, 2010 8:21 AM by 797962 RSS

    Cannot verify MS SQL server source

    797962
      Hi all,
      I faced a problem while trying to verify MS SQL server source with the Oracle Audit Vault
      It is my first experiance with the MS SQL server. On this AV already succesfully registered some oracle and sybase sources.
      MS SQL server2005 x32.

      avmssqldb verify -src srvarch01.rccf.ru:1433
      Enter source username: svc_is
      Enter source password:
      Unable to connect to source database. Please ensure that the source is up and running.
      Error has occurred, please check log for details

      Log:
      Sep 15, 2010 3:11:18 PM Thread-10 FINE: The AV Version is 10.2.3.2.0
      Sep 15, 2010 3:11:27 PM Thread-10 FINE: Exception:com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sv
      c_is'.
      Sep 15, 2010 3:11:27 PM Thread-10 FINE: Exception:Unable to connect to source database. Please ensure that the source is up
      and running.
      com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'svc_is'.
      com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
      com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
      com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
      com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
      com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
      java.sql.DriverManager.getConnection(DriverManager.java:512)
      java.sql.DriverManager.getConnection(DriverManager.java:171)
      oracle.av.plugin.common.DAO.getConnection(DAO.java:161)
      oracle.av.plugin.common.DAO.<init>(DAO.java:134)
      oracle.av.plugin.sql.command.Verify.runQuery(Verify.java:147)
      oracle.av.plugin.sql.command.Verify.checkVersion(Verify.java:224)
      oracle.av.plugin.sql.command.Verify.execute(Verify.java:570)
      oracle.av.plugin.command.Command.process(Command.java:190)
      oracle.av.plugin.sql.command.AVMSSQLDBUtility.execute(AVMSSQLDBUtility.java:92)
      oracle.av.plugin.sql.command.AVMSSQLDBUtility.main(AVMSSQLDBUtility.java:147)

      Will be greatfull for any help.

      Edited by: user12973514 on 15.09.2010 4:16