It doesn't matter at this point whether the server login is a Windows or SQL Server account; they each need you to grant it access to the database. Returning to Enterprise Manager, drill down to the ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results