I connect cross domain with SSMS -- but I have to set up an alias in my SQL Server client configuration.

You can try this:

Follow John's steps to issue the net...

Rainier,

Everything you did was right, members of role_test just need to use the "AS <database_principal>" clause when granting select on testtable.

Try this (assuming testtable is in the dbo schema)