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.
SQL Request Troubleshooting - works in \Run Now\" but not on form"
+1
+11Hi Kyle,
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.
Vadim
+1Thanks Vadim, I have confirmed that the Secure Store creds are correct. Any other troubleshooting ideas? Thanks for the help.
+11Then 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.
Vadim
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.