How do we refer the linked server name in report builder query

• Parthipan-244146

  SSCrazy

  Points: 2178

  More actions

  September 21, 2008 at 4:46 am

  #198271

  Hi All,

  I am getting the error from report designer for the linked server name as below

  could not find the server 'DC01SQLV03' in sysservers

  for the below query

  select System.AD_Site_Name0 as OfficeLocation,

  System.Netbios_Name0 as ComputerName,

  System.Operating_System_Name_and0 as OperatingSystem,

  ENA.UserName,

  ENA.Title,

  ENA.Department,

  ENA.TelephoneNumber,

  ENA.OfficeName

  FROM OPENQUERY(DC01SQLV03,

  'select ENA.Name as UserName,

  ENA.Title,

  ENA.Department,

  ENA.TelephoneNumber,

  ENA.PhysicalDeliveryOfficeName as OfficeName,

  ENA.sAMAccountName

  from [dc01sqlv03\sql_inst3].it_infrastructure.dbo.v_enabledusers ENA') AS ENA

  INNER JOIN dc01sqls01.SMS_D01.dbo.V_R_System System on System.User_Name0=ENA.sAMAccountName

  WHERE System.Operating_System_Name_and0='Microsoft Windows NT Workstation 5.1'

  ORDER BY System.AD_Site_Name0

  Is there any way to refer the linked server like tables and other database objects in the above query.

  But this query works fine in the query analyser in the local server.

  BR,

  Parthi

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 22, 2008 at 7:52 am

  #874983

  Does the user being used for the report connection have rights to use the linked server and rights to the table(s) on the linked server?

  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