• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 13074
  • Last Modified:

Access to the remote server is denied because no login-mapping exists

All,
  I am trying to access an MSQL server through Enterprise Manager. I am trying to update a stored procedure. When I try and save the storeds procedure I get the error "Error 7416: Access to the remote server is denied because no login-mapping exists". This was working fine up until last week and as far as I am aware no changes have been made.
   I am part of the domain admins group and my collegues in that group can alter it but I cannot. I also cannot alter it if I connect to the server as sa.

Any ideas?
0
thesraid
Asked:
thesraid
  • 2
  • 2
1 Solution
 
ram2098Commented:
Your program is using any linked servers? If yes....

In the Linked Server properties, Security tab, make sure you have the correct settings.

Check whether you have the correct access on it.
0
 
thesraidAuthor Commented:
Thanks for the feedback but I am not using any programs. I'm just trying to modify a stored procedure using Enterprise Manager. Presumably linked servers don't apply when simply trying to edit the stored procedure using Enterprise Manager?
0
 
ram2098Commented:
I mean you are having any statements with in your procedure which is accessing linked servers..

like you have any statements...

select * from server.database.table (where server is a remote server)
0
 
thesraidAuthor Commented:
Ah ok that worked. My collegue was specified in the server so that when he accessed the other server he would do so as sa. SO I copied his settings and everything seems to be ok now. Thanks for your help!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now