Hi,

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.

nikita

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 :-)

Nikita

• Marked as answer by nikita.it 18 hours 49 minutes ago

Hi Nikita,

Thanks for sharing the information. Have a good day.

Regards,