SIM 5 stopped and won't restart

[Ken MacEachern]

SIM stopped suddenly and won't start for me again. I tried restarting the service, and rebooting the server but nothing happens. I went looking for log files and found some for DomainManager but I'm not sure what they are telling me. I attached one here.

It appears to be an issue with the connection to SQL but I have no idea how to troubleshoot this any further.

Any help would be appreciated.

Thanks
Ken

[NJK-Work]

Did you recently change the password of the account you used when you install SIM5?

Nelson

[Ken MacEachern]

There's a good chance the password was changed. Is there a way to change the account/password that it is using? Is this account/password used to connect to SQL or other things?

[Joel Rubenstein · Accepted solution]

If you change the password of the account that the SIM service logs into then you must also change the database password since SIM no longer uses Windows NT authentication to access the database. To change the database password use.

mxpassword -m -x MxDBUserPassword="newpassword"

[Ken MacEachern]

The password was indeed the problem. The guy that installed it used a service account we created for most things but apparently used his own domain account somewhere.

Next question is how do I change the account that's being used?

[Joel Rubenstein]

To change the account SIM uses to access the database you need to edit the database.props file. In this file you will see an entry like

hp.Database.username=AETSIM\\Administrator


You can specify a domain user by
DOMAINNAME\\user

You can specify a local user by
systemname\\user

You can specify an SQL user by
user

of course you will then need to change the database password again and also insure the user you specify has DBO rights to the database.

[Ken MacEachern]

Thanks Joel. All is working OK