[ms office - 2007] Infopath to sql data connections

[imiddleton25]

Trying to set a data connection between sql 2005 and infopath

have created it and designed the foem but when i publish it i get

An error occurred accessing a data source.

 

 

An entry has been added to the Windows event log of the server.

Log ID:6932

[FABEnterprises]

I'm not familiar with Infopath but usually this is permission problem communicating with the database either your user credentials are not correct, you don't have right client software on the webserver or the webserver is not allowed/restricted from accessing the DB server, make sure all relevant ports are open on your servers.

 

You might also want to look at this article, might be similar to what you are experiencing.

 

Good Luck

[MattMitchell]

Might be worth checking the log entry on the server to see what it says! Also see if there's anything in the server's access/audit/security logs too.

 

I'll bet money it's one of these though:

 

- wrong user/password

- wrong database instance

- no access for the particular machine/ip you're using

- no access on a particular network interface (less likely but you never know)

 

If there's an entry in the server's log, then it's unlikely to be a firewall or server hostname/ip problem, but just check the database really is where you think it is!