Users

[John]

Hi all,
I have an InfoPath form that is stored on a SharePoint Server that has some
database access to a SQL Server database.

Running from my development PC, I can publish to a SharePoint Server and
view the form with out any problems. But, when I try to get any of the end
users
to open the form, they get a pop up box that asked for SQL Server
Login. The pop up asks for the Server, Use Trusted Connection, Login ID
and Password. The values are pre-populated - but the pre-populated values
are pointing to a database that I no longer use. From my PC, I do not get
this login pop up.

1. Is it correct to assume that these pre-populated values are database
connection string?
2. The user hits "Ok" buton, only to get another pop up window that
states :
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[DBNMPNTW] Specified SQL server not found.

What does this mean? How do I work around this?

Regards,
John

 

[Renee in Juneau]

First, make sure that your Data Connections are valid. You can use the
"Modify" button in the Tools/Data Connections dialog (while in Design
mode) to check this.

Once you're sure the Data Connections are correct and you've saved the
form back to the server, it may work. If not, republish the form to
the Sharepoint Server via File/Publish (in Design mode).

Another thing to check for is your form's security settings (via
Tools/Form Options/Security). On all my forms, I uncheck the
"Automatically determine security level based on form's design" box
and set them to "Domain" level of trust. This gets AD/Sharepoint
involved in validating the user. If your sqlserver is using windows
authentication....

Also, while you're there (in Tools/Form Options) make sure that, in
the "Advanced" tab, the "On Version Upgrade" field is set to
auto-upgrade. If not, the republishing mentioned above may always be a
necessary step.