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
I already did check the website . 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.
Did you ever get connected Ritika? I am also having this same issue. I can connect without issue using sql manager studio but for some reason, this action does not want to connect. I have tried a few different connection strings to no avail. Are their any security settings or central admin configurations that are necessary to allow this action to work?