Access is denied, but Windows User has rights to DB |
chris.boothroy posted on Thursday, August 09, 2007 8:14 PM
|
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
--
Chris Boothroyd
President
Avatar CTS LLC |
 |
|
|
|
HelloWhat is the security level you are using for your Form? |
KalyanGReddyMVPGGKTec posted on Friday, August 10, 2007 6:12 AM
|
Hello
What is the security level you are using for your Form?
--
Kalyan G Reddy - INFOPATH MVP 2007
http://www.ggktech.com |
 |
|
It was set to automatically detect the security level, but I played around |
chris.boothroy posted on Friday, August 10, 2007 1:16 PM
|
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
--
Chris Boothroyd
President
Avatar CTS LLC |
 |
|
Access is denied |
todd golterman posted on Tuesday, March 03, 2009 5:26 PM
|
I am having a similar issue as one you posted several months back (I hope your project worked out). I set up an access database on a laptop at home and am trying to get infopath to access it. I can see the fields, but am getting "Access is Denied".
Did you learn how to fix this? |
 |
|
DB Connection - Access Denied! |
greg appelt replied to todd golterman on Wednesday, November 04, 2009 10:57 PM
|
I also had this problem on my new Win7 Pro box with SQL 2008 and InfoPath 2007. While in design mode of the form, go into the menu selection Tools/Form Options, selecting the Security and Trust category, deselecting the Automatically determine security level, change the radial button to Full Trust and click OK.
The form now can make an ADO connection to the database defined in the data sources. No more Access Denied when attempting to Open, Submit, or Query data!! |
 |
|
|
|
|
Didn't Find The Answer You Were Looking For? |
| View InfoPath Posts Ask A New Question |
|
| EggHeadCafe has experts online right now that may know the answer to your question. We pay them a bonus for answering as many questions as they can. So, why not help them and yourself by becoming a member (free) and ask them your question right now? |
| Ask Question In Live Forum |
|
| If you have an OpenID and do not want to become a member of the EggHeadCafe forum, you can also sign on to Chat Chaos and post your question to our real time Silverlight chat application. |
| Ask Question In Chat Chaos |
|
| Previous InfoPath conversation. |