I migrated a database from SQL Server 2008 to 2012 and also the users.
Now the weird thing is that if the user connects to SSMS on the same server as the SQL Server engine, he can display database properties but he cannot when he uses SSMS to access it remotely (from another machine). He can log, run SQL queries but not display the properties.
Here is the error message:
Even stranger, if I log remotely with
sa, I CAN display database properties but not as a normal user.
I looked around, tried many things, created new users in the new server. But same problem.
I tried this Rights needed to see database files in Properties dialog? in the Securables but the parameters do not seem to be saved. When I reopen they are gone - see screenshot