Menus missing, security issues and Portal Security sync fails with SQL Server 2012 ODBC driver
We're on PT 8.52.15 which supports SQL Server 2012. Our database is SQL Server 2012, but our client version/ODBC has remained on SQL Server 2008 R2 until earlier this week. When I upgraded the client to SQL Server 2012 SP1 CU6, and changed the ODBC DSN to use the 2012 driver we started getting strange security issues in our copy of production environment. When a user logs in, only the top bar is displayed, no menus are available. A user with administrative roles may also not have access to some menus. When trying to run Portal Security Sync, it fails
1