I am trying this out but having problems with the remote user part of the Linked Server.

I have already created the database under another account and this account owns the database. I cannot see how I can now have the user 'MonitoringReportUser' be the owner of teh SQL_Admin Database.

Anyone thired this part out yet and can help with setting this up?