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!

Advertisements

One thought on “Current configuration settings prohibit embedding username and password in the database connection string

  1. Jude Maria Madhan Wellington

    Hi Ryan,

    I am just a user in sharepoint.

    I trying to open a sharepoint link through my ipad. It prompts me for the username and password.

    Is there a way to hardcode the username and password in sharepoint link, so that it does not prompt me for the login credentials?

    Regards,
    Jude

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s