Post reply

Linked Servers

  • January 20, 2003 at 1:39 pm

    #64441

    Anyone know how to create a linked server to a server that has a port other than 1433?

    I keep getting "Sepcified Server not found."

    Cannot find where to set the port in the code.

    sp_addlinkedserver

    @server=

    @srvproduct=

    @provider=

    @datasrc=

    Any ideas?

  • January 20, 2003 at 1:44 pm

    #446798

    I have not done it but may be

    @server=123.456.789.012:9876

    where 123.456.789.012 is the IP and 9876 is the port number?

  • January 20, 2003 at 1:53 pm

    #446800

    Try adding an alias in the client net library with the specified port

  • January 20, 2003 at 1:57 pm

    #446801

    neither one works.

  • January 20, 2003 at 2:22 pm

    #446804

    check that. The alias works.

    Just had to configure it like below, where ServerA_Linked is the alias name.

    EXEC sp_addlinkedserver

    @server='ServerA_Linked',

    @srvproduct='',

    @provider='SQLOLEDB',

    @datasrc='ServerA_Linked'

    Thanks.

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

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