Perhaps too late, but for sake of completeness: Try it with

User=jupd_rw;Password=X?2xY;

and it should work.

Tobias

I am getting an error : Login failed to server . Even though using the credentials I am able to login to SQL Server.

Connection string :

Data Source=localhost;Initial Catalog=DBNAME;User ID=USERNAME;Password=PWD

Userid and password is SQL authentication account

Here You will find a reference how to build the connection string for database access: ConnectionStrings.com - Forgot that connection string? Get it here! 

Just write

User=USERNAME;Password=PWD

as stated above. "User ID" or "UserID" do not work!

Tobias

Edit: Correct that ConnectionStrings.com - Forgot that connection string? Get it here!  writes it has to be "User ID". Just tried it again myself, it works with both "User" and "User ID". Blimey.

I tried that as well but does not work .

I even tested the connection string using a tester from 

http://www.vadimtabakman.com/connection-string-tester.aspx . It is successfull there but on Nintex it is not working. I am using provider as MsSQL in Nintex.