Post reply

Linked server 2005 to 2008

  • May 11, 2010 at 1:47 pm

    #232498

    Hello. Can I create a linked server from a SQL 2005 machine to a SQL 2008 machine? If so, could someone drop me a quick script?

    Ken

  • May 11, 2010 at 5:36 pm

    #1165895

    Yes, you can create a linked server from 2005 to 2008.

    There are many example scripts in Books Online for using sp_addlinkedserver

    http://msdn.microsoft.com/en-us/library/ms190479.aspx

  • May 12, 2010 at 8:57 am

    #1166293

    Have you actually done 1 of these? I've tried a couple variations of @svrproduct and @provider without luck. I can of course connect to this 2008 server from another 2008 machine so my security settings on the target machine are correct.

    Ken

  • May 12, 2010 at 9:24 am

    #1166314

    My bad. My setup was not right after all. I got it. Linked server from 2005 to 2008 is the same as 2008 to 2008.

    Ken

  • May 12, 2010 at 9:27 am

    #1166317

    Glad you got it working. I was just about to supply a simple example. This is if you are using a default instance and not a named instance.

    EXEC master.dbo.sp_addlinkedserver

    @server = N'<your2008servername>',

    @srvproduct=N'',

    @provider=N'SQLNCLI',

    @datasrc=N'<your2008servername>',

    @catalog=N'<your2008dbname>'

    GO

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply