Execute SQL Connection String

+6

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";

+2

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

User=jupd_rw;Password=X?2xY;

and it should work.

Tobias

+1

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

+9

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

+2

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.

+1

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.

Sign up