Trouble Connecting to Linked Server

• sr-523686

  SSC Rookie

  Points: 36

  More actions

  July 6, 2009 at 3:38 am

  #211821

  Hi,

  I have trouble connecting to a linked Oracle server in SQL 2005. The problem is with certain domain accounts regardless of what permissions they have in SQL (Even Sysadmins will not connect). If I make the domain account a local administrator on the Server that SQL is installed then it will work but if I remove the administration priviledges it no longer works. I do not want to give users administrator priviledges just to run simple queries angainst a linked server.

  Please help

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  July 6, 2009 at 9:19 am

  #1020448

  Can you post the settings you have for the linked server? How have you setup login mapping?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question