Error installing the helpdesk portal

This has been kicking my bottom for a week now.

Trying to install the helpdesk portal

here is the error

Expanding Files ….

Expanding Files Complete …
136 files total.
Moving temp folder to C:inetpub
Installing Windows Features
Added ConfigMgr SQL Server Identificateion Certificate ECC2A03D65871BAA36B46742AAA6CBAB1953F240
Set-MachineUserOnSql : Unable to set permissions for machine on SQL server: Exception calling “Open” with “0” argument(s): “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not
accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)”
At C:SoftwareSCCMInstallcd.retail.LNSMSSETUPBINX64MBAMWebSiteInstaller.ps1:1371 char:16
+ $success = Set-MachineUserOnSql
+ ~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Set-MachineUserOnSql

Install-MBAMWebSites : Failure setting machine account privileges on SQL
At C:SoftwareSCCMInstallcd.retail.LNSMSSETUPBINX64MBAMWebSiteInstaller.ps1:1520 char:5
+ Install-MBAMWebSites -SqlServerName $SqlServerName -SqlInstanceNa …
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Install-MBAMWebSites

Uninstalling MBAM web site registry
PS C:SoftwareSCCMInstallcd.retail.LNSMSSETUPBINX64> .MBAMWebSiteInstaller.ps1 -SqlServerName SCCM01 -SqlInstanceName SCCM01 -SqlDatabaseName CM_SS1 -ReportWebServiceUrl https://sccm01.abc.com/ReportServer -HelpdeskUsersGroupName “abcHelpdesk” -HelpdeskAdminsGroupName “abcHelpdesk_Admin” -MbamReportUsersGroupName “abcHelpdesk” -SiteInstall HelpDesk

In PS testing the connection

PS C:Windowssystem32> sqlcmd -sccm01sccm01
1> exit
PS C:Windowssystem32>

Testing ping

PS C:Windowssystem32> ping sccm01

Pinging SCCM01.abc.com [fe80::468c:477:3cdd:a4ba%13] with 32 bytes of data:
Reply from fe80::468c:477:3cdd:a4ba%13: time<1ms
Reply from fe80::468c:477:3cdd:a4ba%13: time<1ms
Reply from fe80::468c:477:3cdd:a4ba%13: time<1ms
Reply from fe80::468c:477:3cdd:a4ba%13: time<1ms

verifying machine name

PS C:Windowssystem32> hostname
SCCM01
PS C:Windowssystem32>

made sure SQL Server service is running

in Sql server configuration manager

SQL server network cofiguration

Protocols for MSSQLSERVER

> all are enabled.

Windows FW is disabled.

clean install 3 weeks ago

windows 2019 server fully patched

Vipre AV

Any and all suggestions are greatly appreciated.

Dennis

This has been kicking my bottom for a week now.Trying to install the helpdesk portal here is the error Expanding Files ….

Ping statistics for fe80::468c:477:3cdd:a4ba%13:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
PS C:Windowssystem32> verifying machine name PS C:Windowssystem32> hostname
SCCM01
PS C:Windowssystem32> made sure SQL Server service is running in Sql server configuration managerSQL server network cofigurationProtocols for MSSQLSERVER> all are enabled. Windows FW is disabled.clean install 3 weeks agowindows 2019 server fully patchedVipre AV Any and all suggestions are greatly appreciated. Dennis Read More

Cart

Cart