java-l |
| jizquierdo | |
Estimados buena tarde, Tengo GX 16U5, SQL Server 2017, Java Web Instale todo en un equipo nuevo. Creé la 1ra KB. Tiene 1 TRN y al darle "Create" de la tabla, sale lo siguiente en el Output: ========== Reorganization started ========== "C:\Models\PruebasClientes\JavaModel\web\callmake.bat" "C:\Models\PruebasClientes\JavaModel\web\GXJMake.exe" "C:\Program Files\Java\jdk1.8.0_191\bin\javac.exe" Reorganization com\pruebasclientes\ options: -O GeneXus Java Make v1.0 Build succeeded. "C:\Program Files\Java\jdk1.8.0_191\bin\java.exe" com.pruebasclientes.Reorganization -nogui -noverifydatabaseschema Error connecting to database at Mon Oct 14 16:13:10 COT 2019 Driver : net.sourceforge.jtds.jdbc.Driver URL : jdbc:jtds:sqlserver://localhost:1433/ User : sa Error : Login failed for user 'sa'. Connection : null Java classpath : ;.;gxclassR.jar;gxcommon.jar;gxcryptocommon.jar;GxGeoSpatial.jar;GxExternalProviders.jar;jackson-annotations-2.9.9.jar;javax.ws.rs-api-2.0.1.jar;simple-xml-2.7.1.jar;jackson-core-2.9.9.jar;jersey-media-json-jackson-2.22.2.jar;xercesImpl.jar;gxmaps.jar;lucene-core-2.2.0.jar;itext-2.1.7.jar;commons-lang-2.4.jar;commons-codec-1.11.jar;joda-time-2.8.2.jar;spatial4j-0.6.jar;jts-1.14.jar;jtsio-1.14.jar;noggit-0.5.jar;GeographicLib-Java-1.49.jar;jackson-databind-2.9.9.jar;xmlbeans.jar;poi.jar;poi-ooxml.jar;poi-ooxml-schemas.jar;commons-collections4-4.1.jar;wss4j-1.6.19.jar;xalan-2.7.2.jar;serializer-2.7.2.jar;slf4j-api-1.7.7.jar;slf4j-nop-1.7.7.jar;bcprov-jdk15on-1.60.jar;bcpkix-jdk15on-1.60.jar;xmlsec-2.1.3.jar;jdom-2.0.0.jar;commons-logging-1.0.4.jar;commons-io-2.2.jar;xml-apis-1.4.01.jar;activation-1.1.jar;log4j-core-2.11.2.jar;log4j-api-2.11.2.jar;javax.mail-1.6.2.jar;jaxb-api-2.3.0.jar;javax.jws-3.1.2.2.jar;jaxws-api-2.2.1.jar;javax.annotation-api-1.3.2.jar;gxmail.jar;javapns.jar;gxsearch.jar;gxoffice.jar;.\drivers\jtds-1.2.jar;.\drivers\mysql-connector-java-5.1.47.jar;.\drivers\ojdbc6.jar;.\drivers\jt400.jar;.\drivers\postgresql-42.2.5.jre6.jar;gxclassr.zip;C:\Tomcat 7.0\lib\servlet-api.jar;.\modules\GeneXus.jar;.\services\GXWebSocket.jar;.\drivers\jt400.jar;.\drivers\jtds-1.2.jar;.\drivers\mysql-connector-java-5.1.47.jar;.\drivers\ojdbc6.jar;.\drivers\postgresql-42.2.5.jre6.jar;.\drivers\sqlitejdbc-v056.jar Login failed for user 'sa'. - code:18456 Error connecting to database at Mon Oct 14 16:13:10 COT 2019 Driver : net.sourceforge.jtds.jdbc.Driver URL : jdbc:jtds:sqlserver://localhost:1433/ User : sa Error : Login failed for user 'sa'. Connection : null Java classpath : ;.;gxclassR.jar;gxcommon.jar;gxcryptocommon.jar;GxGeoSpatial.jar;GxExternalProviders.jar;jackson-annotations-2.9.9.jar;javax.ws.rs-api-2.0.1.jar;simple-xml-2.7.1.jar;jackson-core-2.9.9.jar;jersey-media-json-jackson-2.22.2.jar;xercesImpl.jar;gxmaps.jar;lucene-core-2.2.0.jar;itext-2.1.7.jar;commons-lang-2.4.jar;commons-codec-1.11.jar;joda-time-2.8.2.jar;spatial4j-0.6.jar;jts-1.14.jar;jtsio-1.14.jar;noggit-0.5.jar;GeographicLib-Java-1.49.jar;jackson-databind-2.9.9.jar;xmlbeans.jar;poi.jar;poi-ooxml.jar;poi-ooxml-schemas.jar;commons-collections4-4.1.jar;wss4j-1.6.19.jar;xalan-2.7.2.jar;serializer-2.7.2.jar;slf4j-api-1.7.7.jar;slf4j-nop-1.7.7.jar;bcprov-jdk15on-1.60.jar;bcpkix-jdk15on-1.60.jar;xmlsec-2.1.3.jar;jdom-2.0.0.jar;commons-logging-1.0.4.jar;commons-io-2.2.jar;xml-apis-1.4.01.jar;activation-1.1.jar;log4j-core-2.11.2.jar;log4j-api-2.11.2.jar;javax.mail-1.6.2.jar;jaxb-api-2.3.0.jar;javax.jws-3.1.2.2.jar;jaxws-api-2.2.1.jar;javax.annotation-api-1.3.2.jar;gxmail.jar;javapns.jar;gxsearch.jar;gxoffice.jar;.\drivers\jtds-1.2.jar;.\drivers\mysql-connector-java-5.1.47.jar;.\drivers\ojdbc6.jar;.\drivers\jt400.jar;.\drivers\postgresql-42.2.5.jre6.jar;gxclassr.zip;C:\Tomcat 7.0\lib\servlet-api.jar;.\modules\GeneXus.jar;.\services\GXWebSocket.jar;.\drivers\jt400.jar;.\drivers\jtds-1.2.jar;.\drivers\mysql-connector-java-5.1.47.jar;.\drivers\ojdbc6.jar;.\drivers\postgresql-42.2.5.jre6.jar;.\drivers\sqlitejdbc-v056.jar Thread[main,5,main]: java.sql.SQLException: Login failed for user 'sa'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:599) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:331) at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50) at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at com.genexus.db.driver.GXConnection$1.run(GXConnection.java:473) at com.genexus.platform.NativeFunctions11.executeWithPermissions(NativeFunctions11.java:48) at com.genexus.db.driver.GXConnection.connectJDBCDriver(GXConnection.java:441) at com.genexus.db.driver.GXConnection.connect(GXConnection.java:349) at com.genexus.db.driver.GXConnection.<init>(GXConnection.java:170) at com.genexus.db.driver.GXConnection.<init>(GXConnection.java:111) at com.genexus.db.driver.GXConnection.<init>(GXConnection.java:105) at com.genexus.db.driver.ReadWriteConnectionPool.createConnection(ReadWriteConnectionPool.java:59) at com.genexus.db.driver.ConnectionPool.checkOut(ConnectionPool.java:182) at com.genexus.db.driver.DataSourceConnectionPool.checkOut(DataSourceConnectionPool.java:70) at com.genexus.db.ServerUserInformation.getConnection(ServerUserInformation.java:123) at com.genexus.db.ServerDBConnectionManager.getConnection(ServerDBConnectionManager.java:47) at com.genexus.db.DBConnectionManager.getDBMSVersion(DBConnectionManager.java:166) at com.genexus.Application.getDBMSVersion(Application.java:441) at com.genexus.GXutil.dbmsVersion(GXutil.java:875) at com.pruebasclientes.reorg.previousCheck(reorg.java:155) at com.pruebasclientes.reorg.execute_int(reorg.java:40) at com.pruebasclientes.reorg.execute(reorg.java:31) at com.pruebasclientes.Reorganization.execute(Reorganization.java:39) at com.genexus.GXReorganization.executeReorg(GXReorganization.java:215) at com.genexus.GXReorganization.executeReorg(GXReorganization.java:142) at com.pruebasclientes.Reorganization.main(Reorganization.java:21) Thread[main,5,main] - getDBMSVersion()18456 SQLState 28000 Statement : Login failed for user 'sa'. Exception in thread "main" java.lang.NullPointerException at com.genexus.GXutil.dbmsVersion(GXutil.java:876) at com.pruebasclientes.reorg.previousCheck(reorg.java:155) at com.pruebasclientes.reorg.execute_int(reorg.java:40) at com.pruebasclientes.reorg.execute(reorg.java:31) at com.pruebasclientes.Reorganization.execute(Reorganization.java:39) at com.genexus.GXReorganization.executeReorg(GXReorganization.java:215) at com.genexus.GXReorganization.executeReorg(GXReorganization.java:142) at com.pruebasclientes.Reorganization.main(Reorganization.java:21) Reorganization Failed error: Error in reorganization Create Database Tables Failed En el administrador de SQL Server 18.3.1 puedo conectarme con la autenticación de Windows sin problema. Fui al nodo de seguridad y reseteé/cambié la clave del usuario "sa", sin embargo al intentar autenticarme por SQL Server, sale: [image: image.png] Yo soy el administrador del equipo. Alguna idea que puede ser ? Muchas gracias. Saludos cordiales, Jorge Izquierdo R. |
|
|
| | |
Back to java-l |
|