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";
Solved! Go 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
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.