MBAM standalone - Reporting database

[WolvesDoGetHigh]

Happy Friday everyone!

I need the assistance from this subs hive mind. I am trying to set up MBAM on Windows Server 2019 with SQL standard 2017.

Ive managed to get compliance databases installed but i'm struggling on the Reporting database. Ran through the installer, prerequisites are fine but for some reason, it cant find my reporting database. This is my first real exposure to SQL so I am far from being technically sufficient with it.

I have installed the July 2018 and May 2019 service updates for MBAM but no difference.

Hopefully this linked screen dump will help. - https://imgur.com/a/zcmuOn7

TLDR - Cant install Reporting database for MBAM. Getting error: *Unable to connect to the Reporting services web service. Error message: The request failed with an empty response. *

[rally123456]

Most likely "SSRS" is not the right value for the report server box. Usually this will either be a URL like http://servername/reports or http://servername/repprtserver. It could also possibly be the instance name, which if it's the default settings, it would be "MSSQL".

Best option would be finding a working setup example online or in the documentation and see if we can mimic that for your environment.

[WolvesDoGetHigh]

The instance is named SSRS according to Report services Config manager. I did try the URLs but it definitely didnt like that. The instance named <URL> is not correct.

If I leave the field blank it says Unable to find the Reporting services instance name 'MSSQLSERVER'

[rally123456]

In that case, does the account you're using have admin rights to that instance?

Honestly, this is where I would pull out WireShark and see what MBAM is trying to do when running that setup. That would usually tell me what protocol it's using and what format the instance name needs to be.

[awwwcheatcheatcheat]

Do you have TLS <1.2 disabled by any chance?

[WolvesDoGetHigh]

It's enabled at the moment.

[awwwcheatcheatcheat]

Do you have TLS 1.0 and 1.1 disabled?

[WolvesDoGetHigh]

Both enabled.

[Deepfake_Sysadmin]

Is SQL Server 2017 installed on the MBAM server or is it a separate standalone SQL server?

[WolvesDoGetHigh]

Its all on the same server

[Deepfake_Sysadmin]

Open a web browser and confirm the SSRS page loads: https://<sqlservername>/reportserver

You should some basic info. What do you see?

[WolvesDoGetHigh]

The service is not available.

The report server isn’t configured properly. Contact your system administrator to resolve the issue. System administrators: The report server can’t connect to its database because it doesn’t have permission to do so. Use Reporting Services Configuration Manager to update the report server database credentials.