Access is denied, but Windows User has rights to DB

[chris.boothroyd]

Hi,

I have built and InfoPath 2007 form and supporting (.NET 2.0) web service,
which both work fine on my development machine. However, I am integration
testing the solution on a Windows 2003 Virtual PC Image.

When I host the form on the VPC image, I cannot get InfoPath to connect to
*anything* (not even directly to a SQL Server table). I keep getting "The
query cannot be run for the following DataObject: Main connection. InfoPath
cannot run the specified query. InfoPath cannot connect to the data source.
Access is denied. Access is denied."

I am running as the Admininstrator of the machine, I have DBO rights to the
database, and I can connect to the database using my web service and/or
Excel. In fact, InfoPath is able to connect to the database for the purpose
of generating the form schema (and the TEST SQL button works), but it just
can't get any data.

This is holding up my entire project (due to be installed at 8.00am THIS
Sunday!).

Hope someone is out there.

Best Regards,

Chris

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

What is the security level you are using for your Form?

 

[chris.boothroyd]

It was set to automatically detect the security level, but I played around
with that late last night and managed to get the form to work by changing it
to Full Trust.

Thanks very much for your help.

Chris