cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
markpud
Nintex Newbie

Nintex workflow for Sharepoint 2010 - Execute SQL

Jump to solution

Hi all,

In setting the authentication option for "Execute SQL" it requires the username and password to be hardcoded in.. this means that when the password is changed (we have mandated password changes), the workflow just errors as the authentication fails.

Is there any way around this limitation?

Screenshot of authentication options within the "Execute SQL" option

Labels: (2)
0 Kudos
Reply
2 Replies
Nintex Employee
Nintex Employee

Re: Nintex workflow for Sharepoint 2010 - Execute SQL

Jump to solution

Hi Mark,

I would suggest creating a Workflow Constant with type Credential.  That allows you to centrally and securely store the username/password credentials in the Workflow Constant and use it in the workflow actions where credentials are needed.  This also allows you make only one update to the password should it change.

View solution in original post

Reply
markpud
Nintex Newbie

Re: Nintex workflow for Sharepoint 2010 - Execute SQL

Jump to solution

Thanks @Eric that's an improvement - I can get the site admin to maintain his credentials outside of the workflow.

Reply