Did you try to connect from Excel? If not, here's what I will do based on the info you provided-

Open Excel>Data>From Other Sources>From SQL Server

and then fill out servername-
User Name-
Password-