Post reply

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

  • 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.

  • July 5, 2011 at 4:10 pm

    #1348638

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

    w

  • July 8, 2011 at 6:21 am

    #1350290

    Use the Server Name instead.

  • July 8, 2011 at 11:43 am

    #1350549

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply