OpenRowSet on Local server, getting "remote server is denied because no login-mapping exists"

• bret_aylor

  SSC-Addicted

  Points: 408

  More actions

  January 31, 2011 at 11:02 am

  #99169

  Executing:

  Select 1 FROM OPENROWSET

  ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off

  exec msdb.dbo.sp_help_job @job_name = ''JobAcct'', @job_Aspect = ''Job''')

  WHERE current_execution_Step LIKE '%unknown%'

  Getting this error:

  Error Message: Access to the remote server is denied because no login-mapping exists.

  I have seen posts about login mapping with Linked Servers, but this is on the local machine. Any Thoughts.

• OceanDeep

  Ten Centuries

  Points: 1078

  More actions

  July 5, 2011 at 4:10 pm

  #1348638

  Did u get this resolved? I currently am having the same issue.

  w

• Manish Khattar

  Old Hand

  Points: 399

  More actions

  July 8, 2011 at 6:21 am

  #1350290

  Use the Server Name instead.

• OceanDeep

  Ten Centuries

  Points: 1078

  More actions

  July 8, 2011 at 11:43 am

  #1350549

  Replaceing (local0 with the server name doesn't work either.