Onprem LCS Deployment Error : User is unable to connect to the database server

(0) Share

Report

Posted on by Community Member

Hi,

I have performed all the steps to for D365 on prem environment. Now when I am configuring Sandbox environment it is failing again and again with the sql user authentication error in Fabric cluster.

Please see the attached screenshot.

3527.Untitled.png

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Jelle dH 110 on at

Like (0)

Report

Have you set it up with a SQL cluster or with a single SQL node? If using a cluster, is that node the primary?

I am using a SQL cluster and get random errors in Service Fabric Explorer if the second node is set to primary. When I fail it over to the first node, it automagically resolves the errors on the SFC. It's on my list of tasks to investigate, but I suspect I may have made an error in installation of the SQL cluster.

Was this reply helpful? Yes No