I have downloaded the latest version on PDSAT, as well as the latest version on 19/20 FIS. I have successfully run my ILR file through FIS and obtained all of the usual reports as well as the funding reports.
In PDSAT when I select Import FIS, I’m using the option of connection string and ‘Data Source=(LOCAL)\SQLEXPRESS;Initial Catalog=ILR1920;Integrated Security=True’ based on guidance from a previous forum, but I get a message saying ‘FIS has no funding values. Please run the funding calculations in FIS’.
It looks like PDSAT cannot find SQL server from the connection string you have entered, you should use the Server Name and then the instance name but if you do not have an instance name then leave a space after the ‘\’.
This reply was modified 1 month, 3 weeks ago by Martin West.
The server name is your computer name to find this: open settings – system and click ‘about’ and your server name is the same as the Device name under Device specifications.
Replace the (LOCAL) with your computer name in the string, I expect the instance would be SQLEXPRESS but if this does not work replace it with a space as you may not have a named instance.