Skip to main content
Nintex Community Menu Bar

Connection string : Execute SQL for SharePoint 2016

  • Jun 19, 2017 8:58 PM UTC
  • 3 replies
  • 29 views
  • Translate All

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
  • Jun 20, 2017 7:28 AM UTC

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

Translate

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.

Translate

Forum|alt.badge.img+2
  • Oct 26, 2017 7:49 PM UTC

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? 

Translate