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";
Perhaps too late, but for sake of completeness: Try it with
and it should work.
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
as stated above. "User ID" or "UserID" do not work!
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.
Here You will find a reference how to build the connection string for database access: ConnectionStrings.com - Forgot that connection string? Get it here!
Retrieving data ...