linking servers

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

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

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!

Just had to do this for our new Test server.  Directions I was advised to follow by TStats support staff was section 4.2 in the “T-Stats v2.0 Installation Guide.”  You might be able to adapt those directions for your use as well.

Penny Tabor

IT Manager

Midland Center for the Arts

Midland, MI 48640    

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of John Grigaitis
Sent: Thursday, August 09, 2012 3:49 PM
To: Tabor, Penny
Subject: [Tessitura Technical Forum] linking servers

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

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!