Jump to content

Installation was unable to access the database


Recommended Posts

Hello,

So we're having an issue trying to get the managed console to install. We've spun up a new VM and installed MSSQLServer 2017. We've whitelisted the following on our firewall:

https://data.service.malwarebytes.org , https://data-cdn.mbamupdates.com, https://hubble.mb-cosmos.com, https://*.mwbsys.com, and https://telemetry.malwarebytes.com, all on port 443.

Righ-clicked and ran as admin on the application. We've verified the server and instance name. Triple checked the user name/password, but we keep getting that error message. Any help is much appreciated. Thank you.

 

 

Capture.PNG

Link to post
Share on other sites

Hi @fyang,

Sorry you're having trouble, I'll be happy to help. Is there a particular reason you opted to go with an external database, rather than the embedded one? If not, installing with the embedded database is typically much simpler. If you'd like to stick with the external database, try following the steps below.


Configure Malwarebytes Management Console to use external database

Let me know if that gets it working for you or if you continue to have trouble!

Edited by AdvancedSetup
updated links
Link to post
Share on other sites

Hello, the reason for an external database is because in the best practices guide, it states that it is not recommended for more than 200 endpoints. We have close to 400 endpoints.

I am an entry level Sys Admin and this is the first project of many that I was assigned. It looks like I have a lot to learn! So I've gotten past that error in my initial post. However, I cannot install because I cannot login. This is my first time configuring SQL Server 2016 from scratch. Maybe someone can help? The server and database is up. I can launch it through Microsoft SQL Server Management Studio using windows authentication on the local machine. I've also registered the server by going to View --> Registered Servers within Management Studio. Under Object Explorer, I've expanded Security --> Logins and I've set the Server Roles on all the domain accounts that are listed there as sysadmin. I've restarted the database under Sql Server Configuration Manager. Rebooted the machine. Attempted to login using all of the domain accounts that I've set to sysadmin. Am I missing something? Any help is greatly appreciated. Thanks!

Capture1.png

Link to post
Share on other sites

Got it figured out! For anyone who might run across this issue. What needs to happen first is to launch the newly created database in Microsoft SQL Server Management Studio. Right-click on the Server\database -->  Properties --> click on SQL Server and Windows Authentication mode. Restart the server from Configuration Manager.

Next, log into the database through MSSMS using the sa account. Try it again and it should work. Any questions, let me know. Thanks for all the help guys!!!

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

Back to top
×
×
  • Create New...

Important Information

This site uses cookies - We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.