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

Posted by Allain Lalonde on Server Fault See other posts from Server Fault or by Allain Lalonde
Published on 2010-01-06T21:25:14Z Indexed on 2010/03/19 8:01 UTC
Read the original article Hit count: 206

Filed under:

sql-server-2005

|

linked-server

I've got a Linked Server in my SQL Express install that is using SQL Server Authentication.

I've created a SQL Server login-mapping and it's using Impersonate.

I've confirmed that the account exists on both servers but I'm still getting the error.

Any suggestions?

© Server Fault or respective owner

Related posts about sql-server-2005

[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4

as seen on SQL Authority - Search for 'SQL Authority'
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many… >>> More
SQL Server 2005 - Syncing development/production databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server. My main concern is deploying schema + data updates to developer machines from the "master" development… >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More
Displaying the Row Number in a SELECT Query with SQL Server 2005

as seen on Internet.com - Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row. >>> More

Related posts about linked-server

Can we have Linked Servers when using NTLM?

as seen on Server Fault - Search for 'Server Fault'
I don't have access to the Active Directory settings, nor do I have access to change anything on the linked server. From everything I've read, it seems like this means I cannot use Kerberos - which is a big problem, because I don't know how to use a linked server without it. Is there any way to… >>> More
How do I create a Linked Server in SQL Server 2005 to a password protected Access 95 database?

as seen on Server Fault - Search for 'Server Fault'
I need to create a linked server with SQL Server Management Studio 2005 to an Access 95 database, which happens to be password protected at the database level. User level security has not been implemented. I cannot convert the Access database to a newer version. It is being used by a 3rd party… >>> More
How to Name Linked Servers

as seen on SQL Team - Search for 'SQL Team'
I did another SQL Server migration over the weekend that dealt with linked servers. I’ve seen all kinds of odd naming schemes and there are a few I like and a few I suggest you avoid. Don’t name your linked server for its IP address. At some point whatever is on the other end of that IP address… >>> More
Faster way to transfer table data from linked server

as seen on Stack Overflow - Search for 'Stack Overflow'
After much fiddling, I've managed to install the right ODBC driver and have successfully created a linked server on SQL Server 2008, by which I can access my PostgreSQL db from SQL server. I'm copying all of the data from some of the tables in the PgSQL DB into SQL Server using merge statements… >>> More
How to optimize simple linked server select query?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a table called Table with columns: ID (int, primary key, clustered, unique index) TEXT (varchar 15) on a MSSQL linked server called LS. Linked server is on the same server computer. And: When I call: SELECT ID, TEXT FROM OPENQUERY(LS, 'SELECT ID, TEXT FROM Table') It takes… >>> More