Venkat Katragadda (VenkatK99)
Veteran Affairs

Veteran Affairs
VenkatK99 Member since 2016 4 posts
Veteran Affairs
Posted: June 6, 2019
Last activity: June 7, 2019
Posted: 6 Jun 2019 14:19 EDT
Last activity: 7 Jun 2019 13:49 EDT

SQL DB Connecting errors in Pega Robotics


I am trying to connect SQL Database through Robotics Studio using SQL Query. Initially I selected the "Microsoft OLE DB Provider for SQL Server" and add the rest of the Parameters. It forms the below connection string

"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=XXXXX;Initial Catalog=XXXX;Data Source=XXXXX;Application Name=XXXX"

After clicked the "Test Connection" and it throws an error

"Test Connection failed because of an error in Initializing the Provider.[DBNETLIB] connection Openspan (SECDoClientHandshake()).SSLSecurity Error"

Later I tried to change the Provider to " SQL Server Native Client 11g" in Data Link Properties Test connection was succeeded. But after I clicked ok to save details.

It throws an error in Studio says "Property Value is not Valid" >>> "Keyword Not Supported: 'Server SPN'

Appreciate your help.

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.