SIM 6.1 Warning!! OR HELP!!

[Nicolai Rasmussen]

It's very nice to see that there's actually a bunch of dedicated HP Support guys working on this. Of course if the installation didnt require DBO access to the master db to begin with, this wouldn't have happened. My DBA guys freak out everytime I do a SIM upgrade, because the HPSIM user has to be sysadmin on the entire db instance. This particular incident just tells me that their concerns are actually very substantiated :)

I take it this is only a problem if you run HPSIM on x64?

[Joseph Harlan]

Interestingly enough, I noticed this before I started to plan our upgrade to 6.1(b) from 6.0. I was poking around looking at some things I recall being "twitchy" on SIM 5.3 and I ran into an empty System DSN tab in ODBC. I too am running on Windows 2008 R2 with another server providing SQL 2008 services. Is it possible that something caused the ODBC connections to drop off, or are they no longer required to be set in the System DSN tab of ODBC? My first thought was that SIM was using some internal mechanism for reaching the DB's.

All this being said, I am now having an issue with upgrading from the Insight Software DVD 6.1b that happens during the install wizard right after I enter my SIM service credentials and click next.

SIM Short version: C.06.00 - SIM long version: C.06.00.00
USING SOAP API FOR C.06.00.00 : Peabody
Trying logon with AMER\_svcSIMwin
Error authenticating AMER\_svcSIMwin on HPSIM: System.Web.Services.Protocols.SoapException: javax.ejb.EJBException: java.lang.RuntimeException: java.lang.AssertionError
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at ConfigUtils.Peabody.MxpiMainService.logon(String username, String password)
at ConfigUtils.ICWebServices.SimSoap._SimLogon(String user, String pass)
at ConfigUtils.ICWebServices.SimSoap.Logon(String user, String pass)
Authentication failed!
RETURN CODE: -2008

I am opening a case in the morning. When I finally figure it out, I will post the solution here.

[Joseph Harlan]

So after further checking, I realized that we were using IP Sign-on Restrictions for the service account set in Security > Users and Authorizations so that the service account could only login locally on the SIM Server itself and never be used remotely. I removed the restrictions, and the issue went away and the install is now continuing. Whew!

[Lawrance Lee_1]

Hi Joseph,

Where do I check the settings for this IP Sign on Restriction parameter that you are referring to?