In your case, memory setting need to be revisited as stated by experts in the forum. even if you enable AWE 8 GB memory looks lesser for the size of...

Excellent question. Thanks

You can have a master table containing the server names (from where u want the data) in the server from where you want to run the report and then use...

Have you enabled Mixed Mode Authentication (SQL Server and Windows Authentication mode) in Security?

Were you restoring from the query window in SSMS with selected database as the database you were restoring to?