Use the name of your old server to the new server then copy entire data under mssql and paste it to the new server. dont forget to rename the data...

try to logon as sa and enter your password do not use local system if it will not work click the last button i think it is the connection use...

yes i tried and still it will not work.

   when sql reports an error regarding suspect status it means the 2 servers are not properly communicating. try to add the ip of the subscriber to the publisher hosts...

      go to excel >> data >> import external data >> new database query setup the database you want to access from there you can select the tables or stored...