InfoPath Dev

Yes Jimmy, my SQL instance was using case sensitive collation. I removed that instance and installed new one with case-insensitive.

Now all links are opening correctly. Thank you!

Can you also tell me about QFSConnectionString? Is this enough "Data Source=MYSQLSERVER\FORMSVIEWER;Initial Catalog=FormsViewer;Integrated Security=True". And what accounts should have permissions on SQL database?

Hi Arthur,

It sounds like FormsViewer is successfully querying the database so I think your connection string is fine.

Since you are using Integrated Security, I believe that the only account that would need permissions is the FormsViewer site's app pool identity. It should have both read and write access to the DB.