'No login mapping' error message
From: Loic (loic_nospam_at_yahoo.com)
Date: 12/07/04
- Next message: crshnbrn: "How Do I share SQL Registration from central server"
- Previous message: Jean-Francois Hamelin: "Restricting application to connect to SQL 2000."
- Next in thread: Russell Fields: "Re: 'No login mapping' error message"
- Reply: Russell Fields: "Re: 'No login mapping' error message"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: 7 Dec 2004 08:04:14 -0800
Hi there, I hope someone can help
I am linking my sql server 2000 to another server and I can run a
select statement from tables that were made available to me on that
linked server. However, when I try to access views, I get the
following error message in Query Analyser:
"Server: Msg 7416, Level 16, State 2, Line 1
Access to the remote server is denied because no login-mapping
exists."
I have the same rights on these views as on the tables and yet I can't
manage to select from them.
I have set the login mapping: I have assigned a remote user and
password to my local windows account.
I am running out of ideas.
Any help welcome. Thanks in advance.
Loic
- Next message: crshnbrn: "How Do I share SQL Registration from central server"
- Previous message: Jean-Francois Hamelin: "Restricting application to connect to SQL 2000."
- Next in thread: Russell Fields: "Re: 'No login mapping' error message"
- Reply: Russell Fields: "Re: 'No login mapping' error message"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
