Infopath 2013 data connection to sql error 5566


I created data connection to SQL server and get error 5566.

Converted to udcx and approved. In preview it works fine.

I think the problem is that SP read my user as #!@$lDomain\username

When using data connection to SQL,  how can I send the Right user ?

Pleas your help.


May 27th, 2015 2:50am

Found a solution.

when creating data connection use " user name and password"' username should be local SQL user :  

Moreover, Central administration settings in"  Configure InfoPath Forms Services " under General Application Settings should be :

Hope it will be helpfull for you as it is for me :-)


  • Marked as answer by 18 hours 49 minutes ago
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2015 8:51am

Hi Nikita,

Thanks for sharing the information. Have a good day.


May 27th, 2015 10:14pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics