Hi there,
This is a general error message, could you please share us more error message about this issue from SQL server error log. For SQL Server Authentication, a login with the exact same name and password must exist on the remote server.
The below thread discusses the same issue and you can try out some troubleshooting steps from this and see if that helps you to sort the Issue.
Enable encrypted connections to the Database Engine https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-ver15
------------------------------------------------------------------------------------------------------------------------------------------------------
--If the reply is helpful, please Upvote and Accept it as an answer--