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

Connection string : Execute SQL for SharePoint 2016

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

Labels: (2)
0 Kudos
Reply
3 Replies
mlauer
Nintex Newbie

Re: Connection string : Execute SQL for SharePoint 2016

Please check this connection string reference: ConnectionStrings.com - Forgot that connection string? Get it here! 

0 Kudos
Reply
debeersgroup
Nintex Newbie

Re: Connection string : Execute SQL for SharePoint 2016

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.

0 Kudos
Reply
pallni
Nintex Newbie

Re: Connection string : Execute SQL for SharePoint 2016

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? 

0 Kudos
Reply