Can't connect to local SQL database

Question

Can someone help on how to connect to my local sql server database by utilizing Self Hosted Integration RunTime? I'm currently getting an error message that says "Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'DESKTOP-I2E2IAL\MSSQLSERVER01', Database: 'AdventureWorksLT2017', User: 'mrk'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.

Login failed for user 'mrk'., SqlErrorNumber=18456,Class=14,State=1,

Answer 1

Look in the SQL Server errorlog, which you find in C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER01\MSSQL\LOG\ERRORLOG (assuming an installation of SQL 2022 with the default paths). There should be an error message about the login error with details on why login failed. (Typically, it is at the end of the log.)

You can also view the errorlog by running xp_readerrorlog from a query window.

Answer 2

Hi @Keith Daniel

Login failed for user 'mrk'., SqlErrorNumber=18456,Class=14,State=1

It is suggested to check the SQL Server Error log for more details.

The potential cause might be you're trying to use SQL Server Authentication, but the SQL Server instance is configured for Windows Authentication mode.

You can see a message like the following one in the SQL Server Error log for this scenario:
Login failed for user '<UserName>'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only.

There might exist other potential causes, see this doc for more details and suggested resolutions.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.