Solved

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

Posted on 2004-08-12
4
13,030 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

773 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