https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/54299.aspxWed, 28 Apr 2010 18:26:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:54299Patrick Halstead0https://www.infopathdev.com:443/forums/thread/54299.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=54299<p>Hi Evvo1961,</p> <p>Does your Web Service pass the credentials to SQL? You could test Qdabra&#39;s DBXL which pulls data from SQL and does impersonate the user correctly. Free download on the Qdabra site. Probably a 15 minute exercise (disclaimer: Qdabra is the sponsor of this free forum). Otherwise, you&#39;ll need to look at the code for your Web Service. </p> <p>Happiest of trails,</p>https://www.infopathdev.com:443/forums/thread/54138.aspxMon, 26 Apr 2010 09:21:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:54138evvo19610https://www.infopathdev.com:443/forums/thread/54138.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=54138<p>i have an infopath form that has a number of dropdown controls populated from a sql server database.</p> <p>when the data connections are set within the form then users can access this form fine. ie the username/password are set directly in the connection wizard.</p> <p>however when i tried replacing these feeds with calls to a web service the users could no longer access the form.. but get an access denied error for each method, even though the username / password is the same in the web service method connection string&nbsp;as used in the direct connections before.</p> <p>i see the same type of error if i was to use a windows connection in the connection wizard rather then the infopath user account that was created.</p> <p>does anyone know why the web service methods are not working?</p>