Unable to check SQL authentication in Synchronise database in user profile services in sharepoint 2019 ?

Question

We are trying to creating user profile services in our QA SharePoint 2019 environment, we are using SQL authentication method instead windows authentication. But, we are unable to check SQL authentication in synchronization database, by default it connects windows authentication.
even we try both SQL and windows auth we are getting error:

error: Could not connect to database server using integrated security: Cannot connect to database master at SQL server at database server . The database might not exist, or the current user does not have permission to connect to it.

But, account we are trying connect one having enough permissions to connect it. Even we are using both SQL and Windows Auth getting same error.
We don't want to go integrated security not sure overcome this, we want to create user profiles using sql authentication method. Any help would highly appreciable .

Answer 1

Hi @VSBTEJA
According to your error message, it is recommended that you could check:

1.The SQL Server Service is up and running.

2.The SQL Server Agent is started.

3.The SQL Server Browser Service is started.

4.The database server is reachable and the SQL server port is opened (1433).

5.The Windows Firewall is Off.

6.The TCP/IP network configuration for the SQL Server instance is enabled.

For more information, you could refer to:
https://spgeeks.devoworx.com/cannot-connect-database-master-sql-server-sharepoint-configuration-wizard/

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If the answer is helpful, 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.