Question

1
Replies
299
Views
Close popover
Venkat Katragadda (VenkatK99)
Veteran Affairs

Veteran Affairs
US
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,
Close popover 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.