ytex sql server authentication

[Ephi Sachs]

Hi - 

I'm trying to install ytex in a SQL Server environment. I only have SQL Server authentication to the database, and not Windows authentication.

I get the error below when trying to install, any help would be most welcome!!

Thanks, Ephi

command:

C:\apache-ctakes-3.2.1\bin\ctakes-ytex\scripts\data>..\..\..\ant.bat all > setup.out 2>&1

properties file:

db.name=YTEX

db.schema=dbo

db.url=jdbc:sqlserver://<IP>;databaseName=YTEX;integratedSecurity=true;User=<USER>;Password=<PASS>;

#db.username=

#db.password=

# the schema and catalog (database) where umls is installed

# if not specified, will default to schema/database from ytex

umls.schema=dbo

umls.catalog=umls

rrf.home=<RRF HOME>

# you should not have to modify anything below

db.type=mssql

db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

db.initStatements=

hibernate.dialect=org.hibernate.dialect.SQLServerDialect

# transaction isolation level

db.isolationLevel=READ_UNCOMMITTED

output:

BUILD FAILED

C:\apache-ctakes-3.2.1\bin\ctakes-ytex\scripts\data\build.xml:112: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. ClientConnectionId:86a8e63b-4b90-4331-8151-0dcdb61f0aaa

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)

at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)

at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)

at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:370)

at org.apache.tools.ant.taskdefs.SQLExec.getConnection(SQLExec.java:940)

at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:612)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)

at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68)

at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:197)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:154)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)

at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:435)

at org.apache.tools.ant.Target.performTasks(Target.java:456)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)

at org.apache.tools.ant.Project.executeTarget(Project.java:1364)

at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)

at org.apache.tools.ant.Project.executeTargets(Project.java:1248)

at org.apache.tools.ant.Main.runBuild(Main.java:851)

at org.apache.tools.ant.Main.startAnt(Main.java:235)

at org.apache.tools.ant.Main.start(Main.java:198)

at org.apache.tools.ant.Main.main(Main.java:286)

Total time: 0 seconds

[vijay garla]

In the Url, integrated security should be false

--
You received this message because you are subscribed to the Google Groups "ytex-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ytex-users+...@googlegroups.com.
To post to this group, send email to ytex-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ytex-users/e0b8ed97-4010-423f-9c4d-efa5f6765e4a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.