• Find someone who is an admin on the server.

    That would be the quickest way to resolve it. They should be able to decide how they want to grant access for you.

    Also double check that you are specifiying the instance correctly on your local SSMS.

    If you are not using SA, you still need to connect with SSMS using an account (SQL or Windows) that has access to the database(s).