Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
I can however successfully connect my Self Hosted IR to Postgresql database:
Cannot connect IR to SQL Server on-prem
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 85%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EX%3C/text%3E%3C/svg%3E)
Xee
0
Reputation points
Hi all,
I'm struggling to connect my IR to SQL Server 2019 on-prem.
I've allowed the ports 1433, 433 1434 through firewall.
Attached is the error and the IR details to connect to SQL Server.
Thanks
{count} votes
-
Nandan Hegde 31,511 Reputation points MVP2023-07-31T07:09:25.8633333+00:00 hey,
Can you reattach your image? or provide the error msg as it is not visible
-
Xee 0 Reputation points
2023-07-31T07:15:25.0633333+00:00 Hi Nandan.
Attached is the image and error.
Failed to connect to the database. Error message: Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'XEE-DESKTOP', Database: 'AdventureWorksDW2019', User: 'xenag'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
The user name or password is incorrect
Thanks
-
Nandan Hegde 31,511 Reputation points MVP
2023-07-31T07:52:48.1366667+00:00 Hey,
Can you clarify whether the 2nd screenshot of SSMS connectivity is w.r.t accessing the SQL database from the server hosting the server via SSMS?
Can you open the CMD prompt from the server hosting the IR and execute PING <<Databaseservername>> as well. -
Xee 0 Reputation points
2023-07-31T08:09:55.5833333+00:00 I pinged it and seems ok
-
Nandan Hegde 31,511 Reputation points MVP
2023-07-31T08:25:16.2866667+00:00 And what about:
Can you clarify whether the 2nd screenshot of SSMS connectivity is w.r.t accessing the SQL database from the server hosting the server via SSMS? -
Xee 0 Reputation points
2023-07-31T08:30:42.7233333+00:00 Hi Nandan,
Sorry not sure what w.r.t. is or how to check if wrt is accessing SQL database from the server hosting the server via SSMS?
If you can send me instructions I send you the screenshot :)
Thanks
-
Nandan Hegde 31,511 Reputation points MVP
2023-07-31T09:00:44.3433333+00:00 from which server have you accessed this database : is it from the server on which you have configured IR?
-
Xee 0 Reputation points
2023-07-31T09:09:10.1033333+00:00 Hi Nandan,
Both the IR and SQL Server are installed on my local PC. Name = XEE-DESKTOP
Thanks
-
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee2023-08-03T09:04:05.71+00:00 @Xee - Did you able to resolve the issue or still looking for help on this issue?
-
Xee 0 Reputation points
2023-08-03T09:12:41.41+00:00 -
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee
2023-08-07T07:08:44.24+00:00 @Xee - Could you please share the stack trace of the error message which you are experiencing?
-
Xee 0 Reputation points
2023-08-08T05:48:36.78+00:00 -
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee
2023-08-09T09:56:35.53+00:00 @Xee - Copy entire error message and share here?
-
Xee 0 Reputation points
2023-08-09T10:24:30.49+00:00 This is the entire message from Testing the SHIR:
Failed to connect to the database. Error message: Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'XEE-DESKTOP', Database: 'AdventureWorksDW2019', User: 'xenag'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
The user name or password is incorrect
-
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee
2023-08-14T08:55:09.7933333+00:00 @Xee - Glad to know issue has been resolved. Please do share the what have you done to resolve the issue?
Sign in to comment
1 answer
Sort by: Most helpful
-
Xee 0 Reputation points
2023-08-09T10:29:25.1566667+00:00