Comments by SalCon (Top 4 by date)

Open Object Explorer , Right click on the "Databases" node and select "New Database"

try to play with the month function. Extract the month and use it in the group by and the select list.

Unfortunately I can only connect to the remote server using the SQL login and not the Windows login. :( . You are right that the local admin doenst have access to the remote server.