Thanks for your help.

it is silly but I realized that I was using the server user & pwd instead of the one I created in the EM to access the sql server mng

now all I have to do is create a user account for each student. how can I make sure each user can only see the db they created?

Thank you so much