Solved

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

Posted on 2004-08-12
4
13,024 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
  • 2
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
ram2098 earned 125 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now