Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,443 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' %3EXG%3C/text%3E%3C/svg%3E)
Xena Gillham
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 34,941 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
-
Xena Gillham 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 34,941 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. -
Xena Gillham 0 Reputation points
2023-07-31T08:09:55.5833333+00:00 I pinged it and seems ok
-
Nandan Hegde 34,941 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? -
Xena Gillham 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 34,941 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?
-
Xena Gillham 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 90,601 Reputation points2023-08-03T09:04:05.71+00:00 @Xena Gillham - Did you able to resolve the issue or still looking for help on this issue?
-
Xena Gillham 0 Reputation points
2023-08-03T09:12:41.41+00:00 -
PRADEEPCHEEKATLA 90,601 Reputation points
2023-08-07T07:08:44.24+00:00 @Xena Gillham - Could you please share the stack trace of the error message which you are experiencing?
-
Xena Gillham 0 Reputation points
2023-08-08T05:48:36.78+00:00 -
PRADEEPCHEEKATLA 90,601 Reputation points
2023-08-09T09:56:35.53+00:00 @Xena Gillham - Copy entire error message and share here?
-
Xena Gillham 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 90,601 Reputation points
2023-08-14T08:55:09.7933333+00:00 @Xena Gillham - 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
-
Xena Gillham 0 Reputation points
2023-08-09T10:29:25.1566667+00:00