Post reply

How to create a sql server linked server with not default port code

  • October 29, 2008 at 1:55 am

    #127327

    How to create a sql server linked server with not default port code? I can't find the place where I can put the port code if sql server don't use the default port code.

    C.G

  • October 29, 2008 at 3:14 am

    #891080

    You don't have to define the port number for a linked server. The main reason for this is that named instances by default use a dynamic port which can change after a restart. The SQL Browser service should take care that a linked server connection uses the correct port. Alternatively you can create an alias including the port number in your client configuration.

    [font="Verdana"]Markus Bohse[/font]

  • October 29, 2008 at 3:38 am

    #891086

    Use sp_addlinkedserver instead of sp_addserver but as markusB said it will work for default instance only. For named instance it will not work.

    DBDigger Microsoft Data Platform Consultancy.

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

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