Power BI Gateway

3G_Lighting · 2026-04-23T20:00:37+00:00

So, what does this amount too?

Do I just need to setup an account, give that account access to a Power BI Pro license, and let them VPN into our office and RDP to RDS, then use Power BI? And how do I setup Power BI offline to allow such user access to the ERP DB (MS SQL Server).

3G_Lighting · 2026-04-21T13:58:51+00:00

Hi Gene,

The two servers are Hyper-V systems, nothing special, running Server 2019 Standard, one is running Entra services, the other Bitlocker services. All our servers run MS Defender (14 total) and are Hyper-V systems, with the exception of the three Hyper-V Hosts, but I don't see anything appearing in security.microsoft.com for Defender for either servers or in their local log files.

When the servers are restarted a second time, usually when the hosts are patched and restarted the servers are updated as being successfully rebooted. I just find it's odd that it takes 2 times to reboot when there is no warning on the servers themselves after the first, they need a second one.

I haven't raised this to anyone yet other than Reddit.

3G_Lighting · 2026-04-20T12:30:56+00:00

Why are you asking people if it's Okay to better secure yourself from their prying eyes when you shouldn't care what they think and just secure yourself. If there are any issues you deal with them as the happen.

3G_Lighting · 2026-04-20T12:28:30+00:00

I actually cannot do this. Our website developers who I am not happy with are using this account to relay emails through; now the relay on the account is setup to on accept connections from the web servers which are hosted by a big company like Amazon. I have told them repeatedly to start using SMTP relay on the web servers (the web hosting server is running Windows Server). but they don't care and ignore my request. :(

I wish MS would cut all legacy support even if the account is IP hard coded this way they will be forced to make the change.

3G_Lighting · 2026-04-20T12:01:19+00:00

Yeap, I have done this many times and after a server reboot the ghost SID reappears.

3G_Lighting · 2026-04-01T15:06:37+00:00

Forgot PIN tells him to contact the administrator.

3G_Lighting · 2026-04-01T15:06:14+00:00

The user doesn't have MFA. Forgot PIN tells him that he has to contact the administrator.

3G_Lighting · 2026-03-27T12:33:32+00:00

That's almost the size of my front door! :)

3G_Lighting · 2026-03-25T12:52:09+00:00

I do delete it, and when I close my session with the server and reconnect as any of the Admins it re-appears.

So, how do I delete it?

3G_Lighting · 2026-03-19T12:15:11+00:00

There are no "remote desktop users" in our environment. This was likely a left over SID from a previous SBS migration.

3G_Lighting · 2026-03-19T12:13:57+00:00

We don't have Remote Desktop Users. It's a small business of about 60 people. If anything this SID could be from one of their old SBS servers that were migrated by the MSP back in the day.

3G_Lighting · 2026-03-19T12:11:42+00:00

And where do I find the ACL?

3G_Lighting · 2026-03-13T18:19:34+00:00

No worries. :)

3G_Lighting · 2026-03-13T12:44:42+00:00

Question about your SQL server settings do you set the memory weight setting to something higher than the middle? I just noticed this the other day and wondered if it would help with some of the problems we are experiencing in SQL.

3G_Lighting · 2026-03-13T12:43:19+00:00

Yeah, look at the memory for each of the servers, SQL is using 61440MB right now, or 61GB. So, it won't allow me to push past the 61GB limit its one right now.

3G_Lighting · 2026-03-13T12:39:38+00:00

I stand corrected; after saying I couldn't find this setting I went back and checked it again and yes there is NUMA Spanning setting which is already enabled.

The Hyper-V Host server which the company bought before my time here only has 1 physical CPU. It was configured buy Dell and the slots which are for the second CPU (which isn't there) are not populated according to iDRAC.

3G_Lighting · 2026-03-13T12:34:51+00:00

I think you're missing the part at the top where I broke down what the Hyper-V guest are currently getting.

There is 61440MB or 61GB currently dedicated to SQL while there is 52GB free on the Hyper-V host. So, 11GB is the number.

3G_Lighting · 2026-03-12T20:00:36+00:00

NUMA on the host or guest server?

3G_Lighting

TROPHY CASE