SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,664 questions
How to connect SQL SERVER to ADF using SHIR, It gives some firewall error tried to clear it but I am not able to connect it yet.
![](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(288, 21%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
saidileep yamani
0
Reputation points
I am trying to link my SSMS account to my Azure using SHIR, but when I try to load a table in Azure its giving me an error message which says " Please contact SQL server team for further support. Server: 'DILEEPPC\SQLEXPRESS', Database: 'employeedb', User: 'DILEEPPC\saidi'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. The system could not find the environment option that was entered"
I tried chat GPT and made few changes
- SELECT SERVERPROPERTY('IsIntegratedSecurityOnly') this returns 1 in SSMS
- Check the TCP/IP Port
- Expand SQL Server Network Configuration → Click Protocols for SQLEXPRESS.
- Right-click TCP/IP → Select Properties.
- Go to the IP Addresses tab, scroll to IPAll and check the TCP Port
- Open SQL Server Configuration Manager. Under SQL Server Services, right-click SQL Server (SQLEXPRESS) → Click Restart.
- netstat -an | findstr 1433 returns Listening in cmd
after that my telnet DILEEPPC 1433
is also working but still not able to connect to ADF.
Not sure what else I can do, If anyone know how to solve this issue, please let me know it would be greatful.
Thanks.
{count} votes
-
saidileep yamani 0 Reputation points
2025-03-01T22:15:10.5366667+00:00 -
Erland Sommarskog 119.7K Reputation points MVP2025-03-01T22:37:30.7533333+00:00 Is the Browser service running? It has to be running if you are connecting by instance name.
Then again, if you changed the port, so that SQL Server now listens on port 1433, you can remove the instance name from the connection string.
-
saidileep yamani 0 Reputation points
2025-03-02T02:04:40.8766667+00:00 Thanks for the reply, Erland. Yes I have the ADF running, SHIR Running and SQL SERVER running aswell, and also one more thing, when I try to test connection in SHIR it says "Failed to connect to the database. Error message: Bad JSON escape sequence: \S. Path 'properties.typeProperties.connectionString', line 5, position 75."
Not sure what exactly I need to do to rectify this issue, I have already uninstalled SSMS and installed it back again, still the same. Any help is appreciated. Thanks.
I am not even sure how to reach to MS Support
Thanks.
-
Erland Sommarskog 119.7K Reputation points MVP
2025-03-02T10:31:15.89+00:00 I asked about the Browser service:
Then again, if SHIR runs on the same machine as SQL Server, I don't think it's needed.
"Failed to connect to the database. Error message: Bad JSON escape sequence: \S. Path 'properties.typeProperties.connectionString', line 5, position 75."
Sounds like you have to double a backslash somewhere.
I should add that I don't work with ADF or SHIR myself, so I can guide you there.
Sign in to comment
Sign in to answer