#3 Login problem

[Anna Siso]

Hi all,
when trying to connect to a MS Sql Server 2005 with Windows Autentification (Windows domain user & password),
(where MOA is the server, DGRP_FILTRO is the DBname and AURENSIS\ASiso the Windows Domain\user)

this error appears:

...
Using database properties:
....\SchemaSpyGUI\schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/mssql05.properties

Failed to connect to database URL [jdbc:sqlserver://MOA:1433;databaseName=DGRP_FILTRO]

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'AURENSIS\ASiso'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at net.sourceforge.schemaspy.SchemaAnalyzer.getConnection(SchemaAnalyzer.java:582)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:157)
at net.sourceforge.schemaspy.Main.main(Main.java:42)
I=3E=3

I am using this SQL Server driver: Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar
Thank you very much for your help, in advance
Anna

[John Currier]

If your database is single-sign-on enabled you should be able to use SchemaSpy's -sso option and not specify a userId or password.

If that's not an option then I wonder if SQL Server wants the domain name to be prefixed with \\.

Let me know,
John

[Anna Siso]

Hi John,
this database is not single-sign-on and I have the same error having de domain name prefixed with \\

Regards,
Anna

[John Currier]

Does your database have an instance name?

Do you know what authentication mode it's configured to use? See some discussion of this topic here: http://forums.sun.com/thread.jspa?threadID=5229634

Note that I googled for "com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF" and saw several hits that might be applicable to your scenario.

John