Hi,
Apparently you have some issues with the permissions.
Are you using a different login to connect to
SQL Server from the other PC? If so, it might be that you don't have a required user in the "report" database. Try this:
1. Connect to
SQL Server Management Studio on server machine.
2. Type and execute the following statements (replacing
YourUser
with the name of the login you're using to connect to
SQL Server from the other PC):
USE [report];
GO
CREATE USER [YourUser] FOR LOGIN [YourUser];
GO
If the user already existed, then you should try to remap the login with the DB user:
USE [report];
GO
sp_change_users_login 'UPDATE_ONE', 'YourUser', 'YourUser';
GO
3. Connect to
SQL Server Management Studio from the other PC and check it.
Also, take a look at this:
User can't see database in SQL Server 2008 R2[
^]
Please let me know if you need further assistance.