question

Nethunter-6316 avatar image
0 Votes"
Nethunter-6316 asked Nethunter-6316 answered

Can anyone check my Log for SCOM 2019?

Hi, I'm continuing a question I had last year. I was busy and never solved. I'm attaching a link to the original Thread. I'm trying to Install SCOM 2019. On a Windows Server 2019 Virtual Machine. On VMware. I'm also attaching a Log for my last failed Install. I've enabled RC4 Kerberos, Turned off the Firewall (can't figure how to add sqlbrowser.exe and Port 1434), I think it used Port 1433 during Installation, SQL Browser is running and SSMS is running. I'm using Windows Server 2019, SQL Server 2019 (with CU update from February 2021), and SCOM 2019 Evaluation. Can anyone check my Log and find the problem? Also, the Internet isn't working on my 2019 VM. It's joined to my Domain. (It's not the DC.) I'll solve that later. Can I Offline Install? Please reply. Thanks

https://docs.microsoft.com/en-us/answers/questions/161704/can-anyone-check-my-log-for-scom-2019-install.html

80394-opsmgrsetupwizard2.txt


msc-operations-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BlakeMengotto-9494 avatar image
0 Votes"
BlakeMengotto-9494 answered

You do not need the internet to install SCOM. I looked through the log file and it was still complaining about the account you are using.

Is this SCOM and SQL installed all on the same VM, or is SCOM on an app server and SQL on another server?

The account doing the install needs to have SA access to SQL. To rule out access issues, would you be able to create an account that has local admin access to SCOM and SQL? I would only recommend this in a sand box, not production.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Nethunter-6316 avatar image
0 Votes"
Nethunter-6316 answered

Hi, thanks for your fast reply. I will try different accounts. SCOM and SQL are on the same Virtual Machine. And this is not in Production. Just me at Home. I can try uninstalling SQL and create a new Instance. Then pay attention to the SA access to SQL. I think I used a Service Account and a Built-In Account. Is there a way to create a new Administrator Access without reinstalling SQL? I'll check back in a few minutes. Thanks again

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BlakeMengotto-9494 avatar image
0 Votes"
BlakeMengotto-9494 answered

You don't need to reinstall SQL. So you have a lab at home that has a AD, and this VM is domain joined right? So you have domain admin role, you can create a single service account, and grant it local admin privilege's on that one VM and maybe even give it SA access to SQL (go into SQL management studio, go to security, logins, add an account, select the service account from the domain, and give it SA role). When you install SCOM, use another elevated account, and or log on with the service account and perform the install with it. The only issue you might run into is when setting SPNs, which you can address after the fact.

You shouldn't need to reinstall SQL. Having said that go into SQL management studio and if you have ops manager db and the ops manager dw, delete those databases, before trying to reinstall.

If you have SRS installed and it created the report server db and temp db, then you might have to go into the SCOM install tools folder and run something called srsreset (something like that). I had an issue installing reporting in the past, and SCOM, if it fails to install reporting, it can fowl up the report server, so you have to do a reset, and they have a tool you can use to do that.

I run a all in one in our environment. I use, not best practice, one service account for everything, to be replaced by gMSA soon. You can set this up using one service account.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Nethunter-6316 avatar image
0 Votes"
Nethunter-6316 answered

Hi, that makes sense. Thanks for the reply. I am busy now. I will try that later. SQL management. And delete ops manager db and the ops manager dw. I'll report back. Thanks again

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.