[sims] SIMS "Instance Failure"

[5tu]

Morning All

 

So last night I migrated our SIMS, FMS and Discover databases to SQL 2014 using the latest re-released Migration toolkit from Capita. I then updated SIMS to the latest release. All went fine and the few workstations I tested connected to the new SQL instance without any problems.

 

This morning I'm getting a few reports from users who are getting an error when trying to login to SIMS. Error simply says "Instance Failure".

 

Any ideas anyone?

[wesleyw]

Check the connect.ini and sql.ini files on those workstations

[5tu]

Check the connect.ini and sql.ini files on those workstations

 

It's always the little things!! Yes, for some reason the affected workstation's connect.ini files weren't redirecting to the one on the SIMS share.

 

Thanks again @wesleyw

[wesleyw]

All from experience of migrating SIMS around 5 times at 2 different jobs lol