New SQL server - AutoTrack cannot see databases


New SQL server - AutoTrack cannot see databases

Author
Message
James Hamilton
James Hamilton
Forum Sage
Forum Sage (2.7K reputation)Forum Sage (2.7K reputation)Forum Sage (2.7K reputation)Forum Sage (2.7K reputation)Forum Sage (2.7K reputation)Forum Sage (2.7K reputation)Forum Sage (2.7K reputation)Forum Sage (2.7K reputation)Forum Sage (2.7K reputation)

Group: Forum Members
Posts: 7, Visits: 38
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?

Cheers,

James







--

James Hamilton
Technical Officer - Radio Marsden
GO


Reading This Topic


Login
Existing Account
Email Address:


Password:


Select a Forum....





























Broadcast Radio Forums


Search