Hadeel Jalamneh
Rank: #3886
10Views
4Comments
Integration  with an External Database  Failed
Question
External Database

I Defined a Connection to the External Database ,then Create DB Connection ,after I tried to Connect to External Table or View from integration Studio the Connection to sql server was Failed .
The Error appeared on the attached

101.PNG

0
0
on 2020-12-03
Copy link to comment
Pramod Jain
mvp_badge
MVP
Rank: #51

Hi  Hadeel Jalamneh,

Did you tested the connection after defining the connection string in service studio , by looking at the error it seems like a network issue .


Regards,

-PJ-

1
0
on 2020-12-03
Copy link to comment
Jorge Martins
mvp_badge
MVP
Rank: #19

Hi Hadeel Jalamneh,

Like Pramod mentioned, this looks like a connectivity issue between the OutSystems server and the external SQL Server. In particular, I've seen this type of message in the past when the SQL Server instance was not configured to accept TCP/IP connections (and as such defaults to a Named Pipes connection type that is not supported by OutSystems).

If this is the case, then if you press the Test Connection button for the External Database Connection that you defined in Service Center it should also show an error. And the solution would be to enable TCP/IP connectivity in SQL Server directly.

Hope this helps!

1
0
on 2020-12-03
Copy link to comment