Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2004-08-12
4
Medium Priority
?
13,049 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 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

927 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