<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>nlsimmons.com &#187; Linked Servers</title>
	<atom:link href="http://nlsimmons.com/?cat=11&#038;feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://nlsimmons.com</link>
	<description>Professional Blog &#38; Online Resume</description>
	<lastBuildDate>Wed, 10 Jun 2015 15:02:01 +0000</lastBuildDate>
	<language>en-US</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=4.2.2</generator>
	<item>
		<title>Linked Servers: SQL Server 2005 to SQL Server 7</title>
		<link>http://nlsimmons.com/?p=184</link>
		<comments>http://nlsimmons.com/?p=184#comments</comments>
		<pubDate>Wed, 24 Nov 2010 21:58:32 +0000</pubDate>
		<dc:creator><![CDATA[]]></dc:creator>
				<category><![CDATA[Database Administration]]></category>
		<category><![CDATA[Linked Servers]]></category>

		<guid isPermaLink="false">http://nlsimmons.com/SQLScraps/?p=184</guid>
		<description><![CDATA[Today I had the pleasure of creating a linked server on our main production SQL Server 2005 instance. The catch&#8230;]]></description>
				<content:encoded><![CDATA[<p>Today I had the pleasure of creating a linked server on our main production SQL Server 2005 instance.  The catch is that the server I needed to link was a SQL Server 7 instance.  Here are the steps I took to get the linked server up and running in under 5 minutes flat:</p>
<ol>
<li> Create a new system DSN using the SQL Server (not native client) driver for the server you&#8217;re going to link to.  I used version 6.01.7600.16385.  Walk through the configuration options and modify those that are applicable to your situation.</li>
<li>Right click &#8220;Linked Server&#8221; under Server Objects in Management Studio.</li>
<li>Type a name for the linked server and select &#8220;Other data source.&#8221;</li>
<li>For the Provider, select &#8220;Microsoft OLE DB Provider for ODBC Drivers&#8221;</li>
<li>For Product name, type the name of the DSN you created in step 1.</li>
<li>Data source is the name of the DSN again.</li>
<li>The provider string I used is Data Source=&lt;DSN&gt;;Initial Catalog=tempdb;Integrated Security=SSPI;</li>
<li>Location and Catalog are both blank.</li>
<li>Under the security page, be sure the radio button is selected for &#8220;Be made using the login&#8217;s current security context&#8221;</li>
<li>Set the appropriate options on the Server Options page.</li>
<li>Click OK</li>
</ol>
<p>That&#8217;s it!  You should now have a working linked server setup between SQL Server 2005 and SQL Server 7.</p>
]]></content:encoded>
			<wfw:commentRss>http://nlsimmons.com/?feed=rss2&#038;p=184</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
