Connection string : Execute SQL for SharePoint 2016


Badge +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

Badge +9

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

Badge +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.

Badge +2

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? 

Reply