SQL export works fine for us. I happen to be using SQL Server 2014 Express, but the release notes say it will work with SQL Server 2017. Perhaps you are trying to use integrated Windows authentication? I’d advise using a SQL username with sysadmin privileges initially. You have to put the password in plaintext in the connection string, which is pretty insecure, but if this works then you can tighten up security later. Make sure you’ve got SQL Client software working properly and use SQL Server Management Studio to examine the results.
FIS configuration is stored in ESFA.DC.ILR.Desktop.WPF.exe.Config so you should see something like:
<add key=”IlrDatabaseConnectionString” value=”Server=MYPCNAME\SQLEXPRESS;Initial Catalog=ILR1920;Uid=sa;Pwd=12345″ />
<add key=”OutputDirectory” value=”C:\Users\Me\Documents\FISWorkspace” />
<add key=”ExportToSQL” value=”True” />
You have to have exclusive read/write access to the folder into which you unzip FIS, as the software writes temp files there. So its probably best to run it on the C: drive of a standalone PC, with a local admin user, at least to start with.
Hope this helps.
I have installed the new version of the FIS and tried uploading our ILR Export but it is not processing and saying I need to close window and re-open or contact the helpdesk, which I have done. A colleague, who isn’t available at the moment, I think said to save the uploads in a certain place, but I cannot remember. Can anyone advise if there is a specific place to save or download the exports to? Thanks.