Post reply

Linked Server From 2005 to 2000

  • April 4, 2008 at 11:12 am

    #123278

    I am in need of help trying to add a Linked Server from my SQL 2005. The linked server is SQL 2000 instance (SERVER\DEV).

    What are the proper options that I need to set in order to make this work? I keep getting communication failure.

    Thanks!

  • April 4, 2008 at 12:45 pm

    #798633

    use port number while specifying sql server name

    [font="Verdana"]--www.sqlvillage.com[/size][/font]

  • April 4, 2008 at 12:52 pm

    #798638

    EXEC master.dbo.sp_addlinkedserver @server = N'SERVER\DEV', @srvproduct=N'SQL Server'

    GO

    OR lets say your 'SERVER\DEV' has a private IP '192.168.0.100' and listening port '1115'

    EXEC master.dbo.sp_addlinkedserver @server = N'192.168.0.100,1115', @srvproduct=N'SQL Server'

    GO

    (use comma between IP and port number)

  • April 7, 2008 at 9:32 am

    #799246

    Thank you very much, I got this working!

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

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