I created a SQL User named UserA which was DB_Owner of 1 database. When I connected to this database with SQL Authentication I received the following error:

The server principal “User A” is not able to access the database “DatabaseA” under the current security context. (Microsoft SQL Server, error:916)

To resolve this error I logged in as SQL User UserA, and open theVObject Explorer Details View (press F7). I then right Clicked on the column header and de-selected ‘Collation’. Refresh your databases again and now it should work.