Hi, need help
I set db_datareader role to the Security Login Group for the User Database in SQL2012 instance on Virtual Machine.
This Group cannot see this database in 2008 SSMS under Databases. The only way they can see this database if I would assign this Group a sysadmin role.
The same group does not have any problems to see another User database in 2008 SSMS from another SQL2012 Server with the same role.
This 2nd one is an actual Server (not Virtual Machine) that is probably not a relevant information.
Both Servers have the same version of Windows (Windows 2012) and SQL Server (SQL Server 11.0.3128)
Any help would be greatly appreciated.