information about how you use ‘Get help with ESFA services’. We use this information to make the
website work as well as possible and improve government services.
You have accepted all cookies. You can change your cookie settings at any
This is a new service – your feedback will help us to improve it.
Created 19 July 2021 13:55
Hi All, I am installing PDSAT and trying to connect to the FIS on a new laptop. I am trying to 'Import FIS'.
In FIS 20/21 v 10.1 I am trying to use the following connection String,
Data Source=CMD********\SQLEXPRESS;Initial Catalog=ILR2021;Integrated Security=True
This is what I used previously with success. Now it will not work and in FIS when I 'Test Connection' I get an error, "Unable to connect to the chosen server with specified server and user details. CAny anyone point me in the right direction.
No one has replied to this post.
Yeah, I had a bit of faffing around with this.
In the settings > SQL settings box, I've just got (localdb)\v11.0 (which "connects") but then when I click Import FIS, then I've got the top switch to "Use FIS Connection String" and then the same string you've got above in the box there.
19 July 2021 14:38
Hi Steve. Its when i try to add that string in FIS. I get that mentioned error.
19 July 2021 15:05
AHA! yes, they've changed that bit, just put in [pc name]/SQLEXPRESS not the rest of the string.
19 July 2021 16:21
Ha i got excited there Steve, I tried;
Data Source=[pc name]/SQLEXPRESS
Data Source=pc name/SQLEXPRESS
I've checked it is SQLEXPRESS and am using the correct PC name. It has aged me this today lol..
19 July 2021 17:11
Sorry, my bad (was doing it from memory, rather than checking!), I got my slash the wrong way round!!!!
it's pc name\SQLEXPRESS
20 July 2021 08:20
Sorry accepted haha.. All good. Not sure why i didn't try that one myself.
Appreciate the help. S
20 July 2021 13:16