com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Incorrect syntax near ' LOGIN'.         at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:196)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ erStatement.java:1454)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQ LServerStatement.java:786)         at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute (SQLServerStatement.java:685)         at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)         at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe rverConnection.java:1416)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLSer verStatement.java:185)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLS erverStatement.java:160)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServ erStatement.java:642)         at org.opengts.dbtools.DBConnection.\_executeUpdate(DBConnection.java:716 )         at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:674)

opengts | kernal69 | 7 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Trouble creating databas on a sql 2000 server

    opengts | 7 years ago | kernal69
    com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Incorrect syntax near ' LOGIN'.         at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:196)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ erStatement.java:1454)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQ LServerStatement.java:786)         at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute (SQLServerStatement.java:685)         at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)         at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe rverConnection.java:1416)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLSer verStatement.java:185)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLS erverStatement.java:160)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServ erStatement.java:642)         at org.opengts.dbtools.DBConnection.\_executeUpdate(DBConnection.java:716 )         at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:674)

    Root Cause Analysis

    1. com.microsoft.sqlserver.jdbc.SQLServerException

      Line 1: Incorrect syntax near ' LOGIN'.         at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:196)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ erStatement.java:1454)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQ LServerStatement.java:786)         at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute (SQLServerStatement.java:685)         at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)         at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe rverConnection.java:1416)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLSer verStatement.java:185)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLS erverStatement.java:160)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServ erStatement.java:642)         at org.opengts.dbtools.DBConnection.\_executeUpdate(DBConnection.java:716 )         at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:674)

      at org.opengts.dbtools.DBConnection.executeUpdate()
    2. org.opengts.dbtools
      DBProvider.grantDBUser
      1. org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:655)
      2. org.opengts.dbtools.DBProvider.grantDBUser(DBProvider.java:1766)
      2 frames