06-13-2016 07:07 AM - edited 03-01-2019 09:22 AM
We've upgraded TES 5.3.1 to TES 6.2.1 SP3 instance in our development environment for testing purposes.
We keep receiving the following error:
exception:com.microsoft.sqlserver.jdbc.SQLServerException
reason:Login failed for user 'TES'.
description:Login failed for user 'TES'.
=> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError [SQLServerException.java 197]
=> com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF [tdsparser.java 246]
=> com.microsoft.sqlserver.jdbc.TDSParser.parse [tdsparser.java 83]
=> com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon [SQLServerConnection.java 2529]
=> com.microsoft.sqlserver.jdbc.SQLServerConnection.logon [SQLServerConnection.java 1905]
=> com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000 [SQLServerConnection.java 41]
We've been working with Cisco support for quite some time now but they've not been able to help us so far. They've collected logs from Wire Shark for communication between LDAP and the client manager. It didn't help them so far.
We've team members using the TES web client to perform testing and they keep receiving this error.
We've ensured that the master and the client manager machine configurations are per Cisco's recommendation (medium configuration):
Master: Memory = 16GB, CPU Cores = 8
Client Manager : Memory = 24GB, Cores = 16
Has someone experienced this issue before?
06-14-2016 09:23 AM
Have you restarted your Client Manager service after making changes to the dsp file?
06-14-2016 09:32 AM
Yes I've restarted the client manager service. It didn't help.
06-14-2016 10:54 AM
Have you tried logging into Cache SQL DB using TES (not Admiral DB)? If login fails when connecting, then you should verify that TES is indeed a defined cache user on your Cache SQL DB > Security > Users > TES, or you may need to reset your password with the provided script cm.cmd setcmpwd
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide