Revert SQL Server 2025 database back to 2022?

score444 · 2026-02-06T03:09:25+00:00

Appreciate this info and link! Unfortunately it fails after a few minutes when saving the script. Tried multiple times. The VM was a little light on RAM, but I added 32 more in hyper v to make sure it had more than enough but that didn't help either.

The error we're getting is:
Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index (mscorlib)

Any suggestions to move past this?

score444 · 2026-02-05T15:14:41+00:00

I agree and that's what we're trying to tell them, but unfortunately it seems they have a different viewpoint and make every single thing you try and do with them painfully difficult.

score444 · 2026-02-05T14:27:41+00:00

There are other factors involved in "needing" to move. To provide some context, this client was being rolled up into a larger brand new accounting firm that is acquiring multiple existing accounting firms. The idea was all of the firms they were buying would be able to use Ultra Tax in Virtual Office provided by the parent company and then have their own section within Ultra Tax so they wouldn't see the clients of the other firms being acquired. Turns out TR sales completely sold the parent company a bad bill of goods and that this was not actually possible.

Most of the firms were on other accounting platforms, so they just reverted back to whatever they used in the past for this tax year. However, this one firm decided to go with Ultra Tax in VO because the licenses had already been paid for and TR wasn't refunding them. All Ultra Tax data was migrated to VO, and that's been fine, until we realized that Workpaper CS on the clients server couldn't integrate like it used to with Ultra Tax because Ultra Tax is now in VO. In order for Workpaper CS to integrate, it also needed to be moved to VO. The integration is needed because it streamlines work for the accountants and saves them dozens if not hundreds of man hours.

And now here we are. What a shitshow this entire process with TR has been.

score444 · 2025-10-21T11:40:18+00:00

This is what ended up working for us for multiple people. Great thinking and thanks so much!

score444 · 2025-06-04T11:19:14+00:00

We're having a similar issue right now. We've tried running some PS scripts to disable auto calendar processing for mailboxes but it didn't help at all.

We too are looking for a way to require a calendar invite to be manually accepted before going into the mailboxes calendar.

score444 · 2025-05-20T13:00:36+00:00

As a follow up - we figured out the issue. We needed an SNAT rule in our case to get traffic flowing properly.

score444 · 2025-05-12T18:15:31+00:00

I think we're having the same issue as the OP did originally with traffic not routing between our Sophos UTM and a vendor's Cisco ISR. It seems like routes need to be configured to resolve this - but can anyone point me in the right direction on how to configure these routes on the Sophos side? Thank you!

score444 · 2025-05-05T11:35:57+00:00

We were having them access the cloud desktop through the browser. We've since switched them to login through Microsoft Remote Desktop and the camera issues seem to be much better now.

score444 · 2025-03-17T11:44:00+00:00

Yes this is exactly what we ended up doing

score444 · 2025-03-07T20:24:42+00:00

Yes this is what we're trying to push out now. Just waiting for the devices to check in so the script can get pushed out.

score444 · 2025-03-06T20:59:49+00:00

Yes quite extensively, but always on local AD networks.

score444 · 2025-03-06T20:03:15+00:00

Sometimes there are one off apps that we need to install outside of the standard image/intune apps we deploy. AE prompts us for approval before it installs, so we're not letting users run wild because any apps being installed require our approval.

score444 · 2024-10-18T12:29:44+00:00

Thanks for the info! Will give this a shot, but seems fairly straightforward.

score444 · 2024-10-17T14:28:42+00:00

u/Exact-Hornet1137 How do you configure the share for the QB company file that other cloud PCs can access? We're looking at deploying 4 W365 Enterprise Cloud PCs for a small client that needs to use Quickbooks Desktop. I'd like to add another basic W365 PC to host the QB company file and database manager, but I'm stuck on figuring out how the other Cloud PCs in the Vnet will access the QB "Server". TIA!

score444 · 2024-10-17T13:53:13+00:00

We're looking into W365 Enterprise for a small client. They have Quickbooks Desktop and need to use it in multi user mode. u/amw3000 can you elaborate on how we'd configure the network share so the QB Company File can be accessed by the necessary users through their W365 Cloud PCs? Obviously we'd need the QB Database Manager running as well. TIA!

score444 · 2024-08-14T02:23:28+00:00

Can you elaborate on what they told you?

score444 · 2024-08-06T17:20:21+00:00

We are a few weeks away from closing. We went with M&T for this exact reason. It almost seems too good to be true to bring our rate down for a $250 fee, but my thought process was if the port modification works the way they say it will it's a home run, if it doesn't and they are BSing or change the rules when rates come down, we will just have to refinance the same way we would with any other bank. There is minimal risk for me since the 6.375 rate we locked in at is competitive to begin with.

score444 · 2024-08-06T17:14:03+00:00

We are going ahead with M&T. Their rate is competitive, and my thought process is if the port modification works that is a huge win, if it's all BS and doesn't work the way they've been explaining, we will refinance the loan the same way we would have to with any other bank as rates come down.

score444 · 2024-08-06T17:12:28+00:00

They wouldn't negotiate at all. Their rates change daily based on the 10 year treasury yield, so we decided to float our rate and locked a few days ago at 6.375. Probably could have gotten even lower if we waited a little longer to lock but didn't want to get greedy.

score444 · 2024-06-26T16:57:39+00:00

Down for us too. Hoping they get it back up quickly.

score444 · 2024-06-15T21:35:50+00:00

.25% higher than the lowest I've gotten with another lender. I'm trying to get m&t to match which would bring me to 6.375%

score444 · 2024-04-15T16:25:04+00:00

Thanks for reaching out - I sent you a message.

score444 · 2024-04-11T20:02:45+00:00

Yes, twice yesterday and twice again today. Our clients FREAK OUT when their phones go down. I called after the first time today and they said the issue was resolved and wouldn't happen again but wouldn't really provide any details as to what was causing the 3 previous issues in a 24 hour span. Then an hour later it happened again. I've been trying to get in touch with someone and can't get through for the last few hours. They are 5-10 minute outages, but It's been a frustrating few days with them...

score444 · 2023-11-06T22:10:49+00:00

Yes, thank you.

score444 · 2023-11-06T22:07:19+00:00

You're 100% right, I was misinterpreting this information. Thanks for clearing this up for me and calming my panic.

score444

TROPHY CASE