By James Hamilton - Saturday, April 22, 2023 10:59:35 PM
I've hit a bit of a stumbling block. I've migrated all databases across from MSSQL 2008 R2 to MSSQL 2019. So far so good, after a little fettling Myriad v4 is playing nicely with it.
However, having re-pointed AutoTrack, it can't see any AT databases. It also throws an error saying it doesn't have SysAdmin permissions, but I'm pretty sure it does (see attached). I'm sure it must be an MS SQL permissions thing but I'm stumped. Has anyone come across this before?