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

   hayko98, Apr 19, 2012

   #1
2. Shehap Moderator

   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

   Shehap, Apr 27, 2012

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in