Home Forums SQL Server 2008 SQL Server 2008 - General Unable to access the Linked Server RE: Unable to access the Linked Server

  • September 5, 2012 at 2:45 am

    #1533675

    MuraliKrishnan1980 (9/5/2012)

    SQL Surfer '66 (9/5/2012)

    Is the linked server using the default port 1433? Otherwise you need to specify the port: @server = N'PC068751\SQLEXPRESS,<port>'

    Do i need to specify the port number in the @Server or @datasrc

    You'd better use an alias in the configuration manager and keep the linked server simple.

    -- Gianluca Sartori