SP 2016 deployment failing to deploy, 1805

[amazaheri]

{"code":"DeploymentFailed","message":"At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-debug for usage details.","details":[{"code":"Conflict","message":"{\r\n "status": "Failed",\r\n "error": {\r\n "code": "ResourceDeploymentFailure",\r\n "message": "The resource operation completed with terminal provisioning state 'Failed'.",\r\n "details": [\r\n {\r\n "code": "VMExtensionProvisioningError",\r\n "message": "VM has reported a failure when processing extension 'ConfigureSPServer'. Error message: DSC Configuration 'InstallAndConfigureSharePointServer' completed with error(s). Following are the first few: The user does not exist or is not unique. Object reference not set to an instance of an object. Cannot perform security configuration because the configuration database does not exist. You must create or join to a configuration database before doing security configuration."\r\n }\r\n ]\r\n }\r\n}"}]}

[NikCharlebois]

Ali Mazaheri (@amazaheri) can you send me the list of all items in the resource group and their deployment status? I assume this is related to an issue provisioning one of the SQL Server components. Thanks

[amazaheri]

Microsoft.Template	Failed(Error details)	6/20/2018, 8:31:07 AM	7 minutes 2 seconds	Related events
DeploySPStandalone	Failed(Error details)	6/20/2018, 8:30:58 AM	56 seconds	Related events
DeploySqlStandalone	Succeeded	6/20/2018, 8:29:48 AM	1 minute 12 seconds	Related events
CreateSPVMs	Succeeded	6/20/2018, 8:28:27 AM	1 minute 16 seconds	Related events
CreateSqlVms	Succeeded	6/20/2018, 8:28:22 AM	1 minute 11 seconds	Related events
UpdateVNetDNS1	Succeeded	6/20/2018, 8:27:00 AM	14 seconds	Related events
DeployPrimaryAd	Succeeded	6/20/2018, 8:26:42 AM	1 minute	Related events
CreateADVms	Succeeded	6/20/2018, 8:25:36 AM	59 seconds	Related events

[nimsim]

Same exact problem here:

The user does not exist or is not unique.
Object reference not set to an instance of an object.
Cannot perform security configuration because the configuration database does not exist.
You must create or join to a configuration database before doing security configuration.

I wonder if this has anything to do with the fact that Sharepoint Setup User is the same as admin-user?

Edit: I have no idea, SQL srv seems to have been set up just fine, but after delving a bit more in the errors it seems the problem lies there.

[nimsim]

From Get-DscConfigurationStatus

    "Exception":  {
                       "Message":  "PowerShell DSC resource MSFT_SPFarm  failed to execute
 Set-TargetResource functionality with error message: Cannot access the local farm. Verify that
 the local farm is properly configured, currently available, and that you have the appropriate
 permissions to access the database before trying again. ",
                       "Data":  {

                                },
                       "InnerException":  {
                                              "SerializedRemoteException":
 "Microsoft.SharePoint.PowerShell.SPCmdletException: Cannot access the local farm. Verify that
 the local farm is properly configured, currently available, and that you have the appropriate
 permissions to access the database before trying again.\r\n   at
 Microsoft.SharePoint.PowerShell.SPCmdlet.BeginProcessing()",
                                              "SerializedRemoteInvocationInfo":
 "System.Management.Automation.InvocationInfo",
                                              "ErrorRecord":  "Cannot access the local farm.
 Verify that the local farm is properly configured, currently available, and that you have the
 appropriate permissions to access the database before trying again.",
                                              "WasThrownFromThrowStatement":  false,
                                              "Message":  "Cannot access the local farm. Verify
 that the local farm is properly configured, currently available, and that you have the
 appropriate permissions to access the database before trying again.",
                                              "Data":
 "System.Collections.ListDictionaryInternal",
                                              "InnerException":  null,
                                              "TargetSite":  "Void EndInvoke()",
                                              "StackTrace":  "   at
 System.Management.Automation.Runspaces.AsyncResult.EndInvoke()\r\n   at System.Management.Automa
 tion.PowerShell.CoreInvokeRemoteHelper[TInput,TOutput](PSDataCollection`1 input,
 PSDataCollection`1 output, PSInvocationSettings settings)\r\n   at
 System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection`1 input,
 PSDataCollection`1 output, PSInvocationSettings settings)\r\n   at
 System.Management.Automation.PowerShell.Invoke(IEnumerable input, PSInvocationSettings
 settings)\r\n   at Microsoft.PowerShell.DesiredStateConfiguration.Internal.ResourceProviderAdapt
 er.ExecuteCommand(PowerShell powerShell, ResourceModuleInfo resInfo, String operationCmd,
 List`1 acceptedProperties, CimInstance nonResourcePropeties, CimInstance resourceConfiguration,
 LCMDebugMode debugMode, PSInvocationSettings pSInvocationSettings, UInt32\u0026
 resultStatusHandle, Collection`1\u0026 result, ErrorRecord\u0026 errorRecord, PSModuleInfo
 localRunSpaceModuleInfo)",
                                              "HelpLink":  null,
                                              "Source":  "System.Management.Automation",
                                              "HResult":  -2146233087