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

Execute SQL Connection String

Jump to solution

When using the Execute SQL control, I'm getting the following error

this is the connection string

Data Source=STL-VSQL2012T01;Initial Catalog=INITIATIVE_BENEFITS_TEST;UserId="jupd_rw";Password="X?2xY";

Labels: (2)
Tags (1)
Reply
5 Replies
Highlighted
Nintex Newbie

Re: Execute SQL Connection String

Jump to solution

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

User=jupd_rw;Password=X?2xY;

and it should work.

Tobias

View solution in original post

Reply
Highlighted
Nintex Newbie

Re: Execute SQL Connection String

Jump to solution

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

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Execute SQL Connection String

Jump to solution

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

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Execute SQL Connection String

Jump to solution

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.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Execute SQL Connection String

Jump to solution

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.

0 Kudos
Reply