Post reply

Linked Server From 2005 to 2000

  • 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 3 posts - 1 through 4 (of 4 total)

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