Search EggHeadCafe's Job Board
EggHeadCafe Silverlight WPF ASP.NET VB.NET C# Excel SQL Server SharePoint
search
Miscellaneous GroupsView
Adsi General
Axapta
Greatplains
Helpauthoring
Hiserver General
Infopath
Mac Office
Mac Office Entourage
Mac Office Word
Mac Otherproducts
Mac Rdc
Mac Virtualpc
Macintosh General
Mom
Mshardware Product
Windows File_System
Windows Group_Policy
Windows Msi
Windows Tabletpc
Pos
Servicesforunix General
Simulators
Smartphone
Softwareupdatesvcs
Solomon
Windbg
Windows Terminal_Services
Dataprotectionmanager
Axapta Application
Axapta Programming
Windows Sharedaccess
Fortran
Groove
Msroboticsstudio
Deployment Desktop
Design Gallery
Developer Outlook Addins
Development Device Drivers
Windows Devices Pnpx
.NET Micro
Dynamics Gp Developer
Security Forefront
Internetexplorer Beta
Sv Windows
Development Device Drivers Dtm
Hyper-V
Internetexplorer

Group SummariesView
.NET Framework
Access
BizTalk
Certifications
CRM
DDK
Exchange Server
FoxPro
French
French .NET
Games
German
German .NET
Graphic Design
IIS
Internet
ISA Server
Italian
Italian .NET
Maps
MCIS
Miscellaneous
Mobile Apps
Money
MSN
Networking
Office
Ops Mgr
Publisher
Security
SharePoint
Small Business
Spanish
Spanish .NET
SQL Server
Systems Management Server
Transaction Server
Virtual PC / Virtual Server
Visual Studio
Win32
Windows 2000
Windows 2003 Server
Windows 7
Windows Live
Windows Media
Windows Update
Windows Vista
Windows XP
 

View All Microsoft Infopath Posts  Ask A New Question 

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
reply

 

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
reply

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
reply

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?
reply

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!!
reply

 
 

Previous Microsoft Infopath conversation.