topic Re: sim 7.3 in Server Management - Systems Insight Manager

sim 7.3

PrzemekK — Wed, 11 Dec 2013 01:13:37 GMT

Does anybody tried install it as upgrade or new ? i got some issue with sql like here

http://blogs.msdn.com/b/alexfeng/archive/2013/07/29/sql-server-connection-failed-with-jtds-jdbc-driver-sspi-handshake-failed-with-error-code-0x80090302-state-14-while-establishing-a-connection-with-integrated-security-the-connection-has-been-closed.aspx

Re: sim 7.3

H. Schöbel — Wed, 18 Dec 2013 06:58:46 GMT

Same here. The SIM process tries to authenticate to sql via ntlm (the old and unsecure one). In our network ntlmv2 is forced via GPO, so you get these errors (and a lot other on the sql-server).

I tried to set ";useNTLMv2=true;" in the connection string in hpsim-ds.xml - but this does not help. Is there any way to set the sql authentication mechanism to ntlmv2 or (better) kerberos???

This is a serious problem - our security department is not willing to allow ntlm (old) for the sql-server...

Re: sim 7.3

Andrew_Haak — Wed, 18 Dec 2013 09:15:28 GMT

Sounds like a 7.3.1 version update. I never install a new version of any software unless it is at least 1 month old.

Re: sim 7.3

Pootch — Thu, 19 Dec 2013 10:13:08 GMT

No problems during the upgrade process.

What i have determined is, that the performance of the webinterface went down massive.

Re: sim 7.3

shocko — Thu, 09 Jan 2014 14:47:52 GMT

Just upgraded SIM from 7.1 to 7.3 and hit this immediately.

Re: sim 7.3

PrzemekK — Mon, 17 Feb 2014 15:34:48 GMT

anybody fixed problem with fail to connect to sim database 7.3 ?

Re: sim 7.3

shocko — Thu, 20 Feb 2014 16:21:05 GMT

Hi guys, here is the result of my support case:

This should solve the issue. As suspected, NTLM hardening as fault with use of new JTDS driver.

Note: 2nd link might be dead but should be up soon ;)

Re: sim 7.3

shocko — Fri, 21 Feb 2014 11:16:48 GMT

See attached for resolution if performing an upgrade ;)

Re: sim 7.3

shocko — Tue, 25 Feb 2014 12:31:23 GMT

Tested successfully in my lab.