We've been struggling with variations of the same theme of error message. Generally, the message is:
The following SQL Server error(s) occurred while accessing the Sessions table:
229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'Session', database '<database name>',schema 'dbo'.
We're on Version NA 4.00 SP1 (4.0 SP3)
SQL Server 2005
We've been synching, but nothing works. The only solution is to set the users role to Super (Data) or Super.
Thanks for any pointers.