Data connection now asking for SQL Server login?

pablavo — Tue, 03 Mar 2009 10:48:19 GMT

Hi there,

I'm sure this is a fairly simple one and I just want to be sure I'm not messing things up.

There is an InfoPath form published to a sharepoint 2003 site and I want to alter one of the data connections on the form so that there's sort order. When I click Data Connections from the tools menu and click to Modify one of the data connections I get this message:

The selected database connection saves passwords in a plain text file. Because plain text files are unencrypted and because the database connection is available to anyone using your InfoPath form, this action is not recommended
Do you still want to save the password?

If I click yes, and modify the connection, and then preview the form, everything works as normal. However, If I click No and modify the connection and, then click to preview the form, I receive a popup asking me to enter the SQL login or use a trusted connection.

Does anyone know what I should do? If I click yes to "Save the password", will this effect security, even though permissions are set up within SharePoint?

Many thanks