Hi @Amit Tewari ,
Refer to this, which describe the error states in ‘Show details‘.
You are trying to connect using SQL Server Authentication, verify that SQL Server is configured in Mixed Authentication Mode. For more information on changing SQL Server authentication mode review Change server authentication mode.
Verify that SQL Server login exists and that you have spelled it properly as well.
If your error indicates state 1, contact your SQL Server administrator.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
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.