I'm trying to copy our migration settings from LIVE to TEST by running the MP_Copy_Config procedure.
This requires the servers to be linked
I've tried to figure this out via SQL Server manuals, but keep running into 'jargon' I don't understand; so rather than making more trouble for myself with 'wrong selections' I thought I would ask if anyone can provide some basic instructions on what it takes to set up this "link"
Thanks
John Grigaitis - MOT
John,
Found a quick tutorial online to use Management Studio GUI: http://sqlserverplanet.com/dba/how-to-add-a-linked-server
Hope that helps!
Regards,
Lori
From: John Grigaitis [mailto:bounce-johngrigaitis2251@tessituranetwork.com] Sent: Thursday, August 09, 2012 3:50 PM To: Lori Field Subject: [Tessitura Technical Forum] linking servers
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Lori,
Thanks for the link. Though I still couldn't get the GUI route to work, the article did show a link to the command option.
Looked it up in my SQL Book - seems all I needed was to connect to my LIVE server in SSMS and enter:
sp_addlinkedserver @ server = 'name of my TEST Server'
, @srvproduct = "SQL Server'
and I have a linked server !!!