https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/63270.aspxMon, 17 Jan 2011 13:42:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63270Guy_Lowndes0https://www.infopathdev.com:443/forums/thread/63270.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=63270<p>I have managed to solve part of the problem by copying my data source file from My Documents/My Data Sources to a server location and using that for the database connection.</p> <p>&nbsp;</p> <p>This works with the &#39;sa&#39; account but I&#39;m not sure yet if it works with windows authentication</p>https://www.infopathdev.com:443/forums/thread/63265.aspxMon, 17 Jan 2011 10:55:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63265Guy_Lowndes0https://www.infopathdev.com:443/forums/thread/63265.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=63265<p>Using Infopath 2010&nbsp;</p> <p>I have a an Infopath form that connects to a sql server database.</p> <p>We don&#39;t use Sharepoint&nbsp;</p> <p>The form is published to a network location.</p> <p>I have set up the network connection using the &#39;sa&#39; account and with windows authentication and get the same problem each time.</p> <p>I created users in the database that are identical for every one who will use the infopath form.</p> <p>I can preview the form in designer and it works fine.</p> <p>I can open the form from the published location.</p> <p>Nobody else can open the form, they get a database login form and it does not matter if the select the &#39;Use Trusted&#39; option or login with their windows user name.</p> <p>They can all login using the sql server &#39;sa&#39; account.</p> <p>Any ideas how I can set this up to just use their windows authentication?</p>