If you have a SharePoint UDC and want to embed SQL authentication into it, you need to enable that access from SharePoint. Say you have a InfoPath form, that uses a UDC you have stored in SharePoint, that UDC has a SQL account (like a service account) embedded in it, but when you view your [...]

Continue reading about Embedded SQL Authentiction in UDC’s (Some Config Necessary)