From what you've described, it sounds like an in-place upgrade isn't supported in your setup, which is why the installation keeps failing. The most reliable option is to install...

• This reply was modified 1 weeks, 6 days ago by pdanes.

FWIW - I hope I don't waste more bandwidth - Maybe doublecheck if Express Edition will be able to handle your db(s), load, ... and how you will replace...

• This reply was modified 1 weeks, 5 days ago by pdanes.

Ah, okay - that's the piece I was missing. I didn't realize that going from an older version standard to a newer version Express is considered a downgrade. Thanks for...

I did, before I even posted this question. One of the reasons for these forums is to clear up things that are not obvious from...

Sorry, I don't understand. I asked if it is possible to do an in-place upgrade. You say that it IS possible, but that I have to a side-by-side install and...

Nice. I use similar setups in app-level code, but I never thought to do it in SQL Server. Definitely going into the toolbox.

You're right, of course, but I wouldn't want people to all become too smart. I make a lot of money converting exactly that kind of nonsense into databases, and then...

Thank you, that looks worth considering, although migrating the entire setup to Azure is much more work than I had hoped for just a (seemingly) simple authentication problem. And I...

Thank you, that looks promising. Unfortunately, I cannot do this myself - I have to rely on the IT department, and they are not exactly enamored of my database. They...

My usual method is as follows:

Exhaust every possible avenue of research.

Triple-check everything to ensure I am correct and won't look silly if I have to post a question somewhere.

Repeat...

I had a heck of a time getting FileTables to work. There are four different places that require setting up a special name or alias, and NONE of the documentation...

PowerShell arrays are 0-based. We have 10 elements, so the index goes from 0 to 9. The assignment was $numbers = @(1,2,3,4,5,6,7,8,9,10). So $numbers[0] = 1, $numbers[1] = 2,...

I don't get it. If you set element 4 to Null, why is it that number 5 vanishes from the array?

Really? It...

those "mad" numbers show up frequently in certain plans - they should be ignored.

most of the times if you get a ACTUAL explain plan those numbers will be correct...

• This reply was modified 2 years, 8 months ago by pdanes.