This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(201.6, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hi i am getting below error while i try to connect adf to sql server using self hosted IR , i saw few pages which helps to whitelist the server but i am not sure where to do the changes ?
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'DESKTOP-L0KVROQ\SQLEXPRESS', Database: 'AdventureWorksLT2017', User: 'test1'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
Login failed for user 'test1'., SqlErrorNumber=18456,Class=14,State=1,
Activity ID: 51352b3b-7c08-44e5-a384-4df845df6ed0.
Hey,
Can you please follow below steps and confirm some aspects :
Are you able to access the SQL server via SSMS?
I am getting below error while connecting via SSMS , please let me know if i followed the above step correctly .
Check the SQL Server errorlog. There you will find messages about login failures together but with details on why they failed. You find the errorlog in C:\Program Files\Microsoft SQL Server\MSSQLnn.SQLEXPRESS\MSSQL\LOG\ERRORLOG. (nn is a number that depends on your version of SQL Server.)
Hey it worked , when i tried using windows authentication instead of SQL authentication.
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
You can take a look at the answers below. If it can help you, please accept it.
Hi Himanchal Malewar, Glad to know your issue resolved. Kindly consider marking it as accepted answer. Accepted answers help community as well. Please let me know if any further queries. Thank you.
So it was not a case of network issue :)
Either SQL Auth is disabled on server or the credentials provided were wrong
It was set to only windows authentication when checked.
Hi Himanchal Malewar, Glad to know your issue resolved. Kindly consider marking it as accepted answer. Accepted answers help community as well. Please let me know if any further queries. Thank you.