anonymous Log in
Search
Recents:
v3.0
java-l
Error al conectarse con "sa" en SQL Server 2017, no le gustó la autenticación por SQL Server
14/10/19 21:34

jizquierdo

Replies: 1

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.
Replies

leandro79337933

15/10/19 10:50
Hola Jorge, buen dia, revisa que la seguridad del SQL este en modo mixto (SQL y Windows): [image: image.png] Slds On Mon, Oct 14, 2019 at 6:36 PM Jorge Izquierdo < jizquierdo@doit-innovations.com>


Back to java-l