Database Replication.I Cant connect to a SQL server that is using windows Authentication

3
How would i connect to a sql server that is using windows authentication, without using the sql server authentication option? com.mendix.core.CoreException: Exception occurred in action 'Microflow [DatabaseReplication.IVK_GetAllTableInfo]', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.CoreAction.d(SourceFile:553) Caused by: com.mendix.core.CoreException: Exception occurred in microflow 'DatabaseReplication.IVK_GetAllTableInfo' for activity 'Sync the database', all database changes executed by this microflow were rolled back at kP.b(SourceFile:251) Caused by: replication.ReplicationSettings$MendixReplicationException: Could not connect with the database at location: jdbc:sqlserver://cptdevsqlsnap01\SNAP_Data;databaseName=SNAP_Data at databasereplication.implementation.DatabaseConnector.connect(DatabaseConnector.java:92) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host cptdevsqlsnap01, named instance snap_data has failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171) at com.microsoft.sqlserver.jdbc.SQLServerConnection.getInstancePort(SQLServerConnection.java:3174) at com.microsoft.sqlserver.jdbc.SQLServerConnection.primaryPermissionCheck(SQLServerConnection.java:937) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:800) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at databasereplication.implementation.DatabaseConnector.connect(DatabaseConnector.java:87) at databasereplication.implementation.DataManager.startSynchronizing(DataManager.java:107) at databasereplication.implementation.SQLServerReader.processTables(SQLServerReader.java:35) at databasereplication.actions.SyncDatabaseInfo.executeAction(SyncDatabaseInfo.java:48) at databasereplication.actions.SyncDatabaseInfo.executeAction(SyncDatabaseInfo.java:25) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at it.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:191) at hi.a(SourceFile:70) at kP.a(SourceFile:66) at eO.executeAction(SourceFile:96) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) at it.b(SourceFile:155) at com.mendix.core.Core.execute(SourceFile:191) at dw.execute(SourceFile:183) at ju.a(SourceFile:299) at ju.a(SourceFile:230) at ju.processRequest(SourceFile:174) at fC.a(SourceFile:71) at com.mendix.core.MxRuntime.processRequest(SourceFile:916) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:42) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662)
asked
2 answers
1

You mean the standard authentication doesn't work and produces this stacktrace?

Make sure you check all this: "Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host."

Edit: Ok, but you entered the login and password to the Database entity you are loading in the DB replication? I think the App only supports normal MSSQL authentication.

answered
1

For now i just went into the sql server management studio and created a sql server authentication login for mendix. The Standard windows authentication does not seem to work here.

answered