I am trying to do a very simple query in the SQL request control. When I'm configuring the action and click the Run Now button it works fine, but when I preview or publish the form it doesn't populate anything in the drop-down. I'm on SharePoint 2013, forms version 2.9. Anyone have any ideas on how to troubleshoot this? Does it use the Secure Store config during the run now process or does it use my login? Thanks in advance for any help.
it should be using the Secure Store creds in both the Run Now and at Run Time.
But, I'd still recommend you check your creds in the Secure Store to make sure they are correct.
Then I would recommend you check 2 other things.
1. SharePoint ULS logs to see if anything is logged there around the time you open this form.
2. See if there's any kind of SQL logs that might help explain if it is a credential issue. I haven't looked into SQL logging, so I'm just guessing here.
I Created a new Secure Store id, it works on Run Now but not in the Form(i am using a dropdown). I am using a Trial of Nintex Form.
Please help. I am not a SQL Guru.
Thanks and Regards,