Broadcast Radio Forums

New SQL server - AutoTrack cannot see databases

By James Hamilton - Saturday, April 22, 2023 10:59:35 PM

Hello all,

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?