2003 Web-published form prompts for password on open

[zeon]

First, I apologize for my lack of web knowledge. Have published a working
..xsn file to the web using the 2003 publish wizard. We don't have Office 2007
deployed yet.
Publish works OK, but when users attempt to open the form, it prompts them
for a web-publishing password 3 times. If they don't enter anything, but
instead click the cancel button on the dialog box, the InfoPath form does
then appear, and they can successfully use it. I want to eliminate the
userid/password prompt from our web system.

Is it possible that Infopath opens the form in read/write mode, and that is
why our system is prompting for the password? If that is the case, is there a
way to turn this off? Thanks!

 

[Clay Fox]

Hey Zeon.

First you would want to check your permissions in IIS. make sure the users
have the correct permissions for the location where you have published the
form.

Are they using Vista on the clients? There is a known issue with Vista
asking for credentials again and again.

Also do you have any secondary connections that the form connects to that
might also need permissions?

Lastly your website should be in the intranet or trusted security zone in
Internet Explorer for your users. This will reduce the security warnings you
may get.

 

[zeon]

Clay, thanks. Must the folder where the form is published on the web be
writable by all who use the form? That is what this link seems to indicate:
http://office.microsoft.com/en-us/infopath/HA011417761033.aspx#2
With this stmt: Ensure that users have write permissions to the shared
folder If you publish a form to a shared folder, you must make sure that
your users have write permissions to the shared folder before publishing the
form. This enables your users to fill out the form and save it back to the
same folder.

Does that then mean that anyone using the form could make changes to the form?
Thanks.

 

[Clay Fox]

The template, the .xsn file, is different then the completed forms which are
an XML file. Where are they submitting the completed forms to?

You can secure the XSN file differently then the rest of the folder if needed.
In theory someone could update the template if you do not set specific
permissions. Also you should turn off the design mode option and go through
your form options and make sure you have it configured for production.

There are some advantages you get publishing to SharePoint or SQL that you
do not get with a file share.

 

[zeon]

Clay, excuse my ignorance, as I'm still learning InfoPath. I have my data
source pointing to an SQL database which is located on an SQL cluster that is
different from where the XSN is published on the web, so I guess they are not
sending the form XML anywhere (I guess that is why, everytime they exit the
form, it asks if they want to save it, to which I've told my users to reply
no). Thanks.

 

[Clay Fox]

Oh so the form is just to view and update SQL records directly.
If that is the case then go into form options and uncheck the Save and Save
As. This will eliminate the prompt.

I have doen this but witht he form published to a web site. You may have to
give them write permissions on the folder since it is on a share.

If you are working with SQL you may want to check out switching to web
services at some point. I usually start to run into some of the limitations
of the defualt SQL connection eventually, such as not being able to
dynamically query or submit to tables other than in my main table structure.

 

[zeon]

Clay thanks for the suggestion, but for some reason, this did not solve the
problem. I still get 2 web-pass prompts before the form opens. Also, with the
save and save as unchecked, it now gives this newprompt when closing the form
(even if no changes were made):
"Do you want to submit form1?"

Thanks for your patience!