SQL Server Performance

linked server

Discussion in 'ALL SQL SERVER QUESTIONS' started by hayko98, Apr 19, 2012.

  1. hayko98 New Member

    I created linked server using following script On my dev server:
    EXEC sp_addlinkedserver
    @server='prd'
    ,@provider='SQLNCLI'
    ,@srvproduct=''

    Connection is fine.When I expand ‘Catalog’ folder from newly created Link server it shows databases that I have on my dev server.I can not see prd\databases.Any idea why?

    Thank you
  2. Shehap MVP, MCTS, MCITP SQL Server

    It is mostly probable some alias is exists on your dev machine to use "Prd" as an alias to refer to your dev server , thereby you have to double check SQL Server alias exists on your machine using SQL Server client network utility (Run >>> Cliconfg.exe)

    If still persist , please let me know to work out other assumptions

Share This Page