Skip to main content
Nintex Community Menu Bar

Connection string : Execute SQL for SharePoint 2016

  • June 19, 2017
  • 3 replies
  • 26 views

Forum|alt.badge.img+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

3 replies

Forum|alt.badge.img+9
  • June 20, 2017

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


Forum|alt.badge.img+1

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.


Forum|alt.badge.img+2
  • October 26, 2017

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?