Yet again I’m having problems with FIS – when I try to open it it keeps asking for the storage settings (which have never been changed from the default). This happened to me a few months ago and I ended up scrapping it and reinstalling from scratch, given it has to download last year’s data as well as this year’s it can be a long process.
Does anyone know a way of fixing this without having to reinstall?
Thanks.January 30, 2015 at 10:28 am #12953
This happens to me occasionally because the SQL Server service has not started.
Open up Control Panel and go to Administrative Tools –> Services. Look for the service called “SQL Server (SQLEXPRESS)”. If it is not showing “Started” in the Status column, right click on the service name and click on Start. Give it a few seconds to start then try opening FIS again.January 30, 2015 at 10:57 am #12958
Stuart got there first but for info,
The named Instance (SQLExpress) as default should match the name of your server which you can check using Control Panel – Administrative Tools – System Information then select Software Environment, Services and check the display name which should match ’SQL Server (SQLEXPRESS)’ if the bit between the brackets is different change your named instance in FIS to it.
If you cannot find SQL Server than you have an issue and will need to reinstall.January 30, 2015 at 11:02 am #12959
That’s really helpful. Something that’s been intermittently driving me up the wall as well for a couple of months now! Thank you!January 30, 2015 at 11:07 am #12960
I have had this problem a couple of times and if the above doesn’t work (I tried this route and did wasn’t successful for me) I have found that a complete removal of FIS and all it’s components (option when you uninstall) and then re-install sorts out all the issues nicely.January 30, 2015 at 11:16 am #12963
Forgive me, but uninstalling and re-installing is a workaround. The software should not be so flakey (unless the user is digging in the back causing it to break).
The solution about checking that SQL server is running is clever, but why would it stop if the user has done nothing? Should not FIS include a routine to check and start this itself, if required?January 30, 2015 at 11:31 am #12965
This issue is not an issue in FIS but an issue caused by the setup of the computer on which FIS is installed and this has normally found to be due to the version of SQL server used or where the installation is different to that specified.
HTHJanuary 30, 2015 at 11:42 am #12966
Thanks for the information Stuart, FIS is working now, albeit the update won’t work due to another error “An internet based service used by the application is currently unavailable or reporting a problem”… Presumably an error caused by a similar problem with a service?
Error Code: 0014.January 30, 2015 at 11:50 am #12968
Yes, I was getting the internet-based service error earlier, it’s very common and can be ignored.
I recommend not trying to open FIS until a couple of minutes after boot up to give the SQL Server service maximum chance of starting by itself. But it’s still not 100% reliable. To be honest this is presumably Microsoft’s fault, though as Caspar says, if FIS were written better than it would do these checks itself.January 30, 2015 at 12:26 pm #12973
You must be logged in to reply to this topic.