Question

1
Replies
266
Views
VenkatK99 Member since 2016 4 posts
Veteran Affairs
Posted: June 6, 2019
Last activity: June 7, 2019
Closed

SQL DB Connecting errors in Pega Robotics

Hello,

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
Share this page LinkedIn