I am getting the following error when running an SQL task with an OpenQuery:
Error in SQL query: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Access to the remote server is denied because no login-mapping exists.
I am trying to hit a Netezza server with the OpenQuery. I have performed plenty of other OpenQuery runs with no problem using SQL tasks in VC and cannot figure out what the difference is other than the server I'm trying to hit this time is Netezza. Also, the remote SQL server I'm connecting to in order to run the SQL tasks has the necessary ODBC driver(s) since I can run the query just fine in SQL Server 2012.

1. are you using the same Connection as in other Tasks?
2. are you using the same Credential as in other Tasks?

---

Hi Henrik,

Yes to both. I cloned one of the existing tasks as my starting point.

But, if you have one working and you just clone it it works right? Please confirm.

If you just cloned - what else have you changed. It does not sound likely that the query is the problem.

---

Correct. The only thing that has changed is which LinkedServer I'm trying to hit with the OpenQuery.

Here is a similar problem. Perhaps connection string is tied to it.

http://blogs.technet.com...ogin-mapping-exists.aspx 

---

The link seems to be broken...

The link seems to be broken...

Try again now.

---

Thanks. I came across that article at one point but I'm not sure why that would be the same issue since I can run it just fine in SQL Server 2012 on the remote server that the SQL task points to without entering any additional credential parameters into the query.

For whatever reason, I was able to ultimately work around this issue by changing from an SQL task in VC to an "Execute" (cmd shell) task and using the "Command:" input "sqlcmd" with the proper arguments. Exact same code just, running directly in a shell.

Ok, great, really hard to say from here as we do not have the same environment but I am glad you found a workaround!

---