January 31, 2011 at 11:02 am
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
Did u get this resolved? I currently am having the same issue.
w
July 8, 2011 at 6:21 am
Use the Server Name instead.
July 8, 2011 at 11:43 am
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