?
Solved

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

Posted on 2004-08-12
4
Medium Priority
?
13,045 Views
Last Modified: 2011-08-18
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
Comment
Question by:thesraid
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
ram2098 earned 375 total points
ID: 11782384
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
 
LVL 2

Author Comment

by:thesraid
ID: 11783469
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
 
LVL 11

Expert Comment

by:ram2098
ID: 11783512
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
 
LVL 2

Author Comment

by:thesraid
ID: 11783594
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

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question