sim 7.3 (861 Views)
Reply
Frequent Advisor
PrzemekK
Posts: 39
Registered: ‎07-31-2012
Message 1 of 9 (861 Views)

sim 7.3

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-driv...

 

 

 

Advisor
H. Schöbel
Posts: 18
Registered: ‎04-01-2007
Message 2 of 9 (742 Views)

Re: sim 7.3

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...

Trusted Contributor
Andrew_Haak
Posts: 463
Registered: ‎09-13-2013
Message 3 of 9 (734 Views)

Re: sim 7.3

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.

Kind regards,

Andrew
Frequent Advisor
Pootch
Posts: 49
Registered: ‎11-14-2012
Message 4 of 9 (707 Views)

Re: sim 7.3

No problems during the upgrade process.

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

Honored Contributor
shocko
Posts: 883
Registered: ‎11-13-2008
Message 5 of 9 (625 Views)

Re: sim 7.3

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

If my post was helpful please award me Kudos! or Points :)
Frequent Advisor
PrzemekK
Posts: 39
Registered: ‎07-31-2012
Message 6 of 9 (446 Views)

Re: sim 7.3

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

Honored Contributor
shocko
Posts: 883
Registered: ‎11-13-2008
Message 7 of 9 (408 Views)

Re: sim 7.3

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 ;)

If my post was helpful please award me Kudos! or Points :)
Honored Contributor
shocko
Posts: 883
Registered: ‎11-13-2008
Message 8 of 9 (404 Views)

Re: sim 7.3

See attached for resolution if performing an upgrade ;)

If my post was helpful please award me Kudos! or Points :)
Honored Contributor
shocko
Posts: 883
Registered: ‎11-13-2008
Message 9 of 9 (388 Views)

Re: sim 7.3

Tested successfully in my lab.

If my post was helpful please award me Kudos! or Points :)
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.