SQL Database Integration

Re: Getting Access Denied Error while making a connection

Nipendra Garg — Thu, 17 Dec 2009 08:02:15 GMT

Hi Hilary,

Thanks for the reply..

yes, I tried to create a connection many times, but every time after making a connection, whenever I am trying to preview the form, I am getting same error.

Don't know, how to get rid of this issue.

Re: Getting Access Denied Error while making a connection

Hilary Stoupa — Tue, 15 Dec 2009 15:43:51 GMT

If you can access the table in SSMS using your windows authentication, there is no reason you shouldn't be able to access it from InfoPath. Have you tried recreating the data connection?

Re: Getting Access Denied Error while making a connection

Nipendra Garg — Thu, 10 Dec 2009 05:37:37 GMT

Hi Hilary,

yes, I am actually using windows authentication to connect with database as well as to login in sql server 2008.

is windows authentication is not working to connect database from infopath..? Any other possible reason..?

Thanks in advance to share your exp in this regard.

Re: Getting Access Denied Error while making a connection

Hilary Stoupa — Thu, 10 Dec 2009 01:57:52 GMT

Did you use windows authentication or SQL authentication when you created the connection? I mean, the error you are getting really does tell the whole story, you are being denied access to the table you are requesting data from...

Re: Getting Access Denied Error while making a connection

Nipendra Garg — Wed, 09 Dec 2009 06:17:42 GMT

Hi Hilary,

Thanks for the response, Actually I opened MS Infopath 2007 for first time, it was totally blank, there was no existing connection. I created a new data connection with SQL Server 2008.so i think this is the primary data connection (I do not have much idea abt primary and secondary).

After create this data connection (to receive data from SQL Server) I simply took one drop down and bind the dropdown value from external data source column value. When I click on the preview button, I am getting three button :

1. Work Offline 2. Try to Connect (When I clicked ion this button, I got one popup saying that, Infopath connected to data source but failed to receive data)

3. Show Details -> when I clicked on this button it shows :

The query cannot be run for the following DataObject: OEE_Data

InfoPath cannot run the specified query.

InfoPath cannot connect to the data source.

Access is denied. Access is denied.

Any help on this regard will be appreciated.

Re: Getting Access Denied Error while making a connection

Hilary Stoupa — Fri, 04 Dec 2009 23:14:52 GMT

You get this error when you try to create the secondary data connection in your form template?

Re: Getting Access Denied Error while making a connection

Nipendra Garg — Fri, 04 Dec 2009 04:43:37 GMT

I am using SQL Server 2008 and I am getting one popup saying that "Datasource is connected but unable to retrieve data".

I dont know why I am getting this kind of error. Any help in these regards will be appreciated.

Re: Getting Access Denied Error while making a connection

Hilary Stoupa — Thu, 03 Dec 2009 20:30:05 GMT

Hi -- are you able to connect to the server? When you create the data connection, are you using Windows Authentication? Or SQL? If you are using SQL, are you saving the connection string?

Getting Access Denied Error while making a connection

Nipendra Garg — Thu, 03 Dec 2009 06:42:18 GMT

Hello Everyone, This is the first time I am using Infopath and I got stuck with "Access Denied" error. I created a data connection (to receive data from SQL Server) and then I simply took one drop down and bind the dropdown value from external data source column value. When I click on the preview button, I am getting three button :

1. Work Offline 2. Try to Connect (When I clicked ion this button, I got one popup saying that, Infopath connected to data source but failed to receive data)

3. Show Details -> when I clicked on this button it shows :

The query cannot be run for the following DataObject: OEE_Data

InfoPath cannot run the specified query.

InfoPath cannot connect to the data source.

Access is denied. Access is denied.

Can anyone please help me as I dont know why I am getting this Access Denied error. Any help would be appreciated......Thanks