InfoPath Designer 2010 and SharePoint 2010 are a great team!

In case you’re not as fortunate as me and you haven’t had the privilege of experimenting with SharePoint 2010 and the new Form Templates available in InfoPath Designer 2010, here are some cool things you can do without code!

  1. Create a custom branded User Profile Lookup Form to talk to the UserProfileService.asmx web service. Pull in data such as Preferred Name, E-mail address, Profile Picture, Department, Manager, etc. Put this in an InfoPath Form Web Part and give the user a nice UI for querying your Active Directory.
  2. Create a custom Site Provisioning Form to talk to the Sites.asmx web service. Wrap an approval workflow around it so that when the manager approves the site request it gets auto-provisioned. The user doesn’t need permission to create sites because you can run it with elevated privileges. The manager doesn’t need to manually create the site for the user after approving it; everyone wins!

These are just two of the cool things you can do with SharePoint 2010 and InfoPath 2010.

Current configuration settings prohibit embedding username and password in the database connection string

My migration to SharePoint 2010 from SharePoint 2007 went mostly smoothly. One exception to that statement was getting my data connections in InfoPath Forms Services to work again.

I came across this error today:
Current configuration settings prohibit embedding username and password in the database connection string

A quick check of the InfoPath Form Services settings in Central Administration>General Application Settings>InfoPath Form Services>Configure InfoPath Form Services resolved my problem…

I needed to allow:
Embedded SQL authentication
User form templates to use authentication information contained in data connection files
Cross-domain data access for user form templates that use connection settings in a data connection file
Saving those settings got my data connections working again!