I've stripped the whole thing down to isolate the one line that is causing the problem.  It's this line that selects from the table I put the DENY on.  It...

I'll try to answer the questions all in one post here.

1. I'm not posting the full DDL of objects because there are only 2 views that are joined.  However, one...

@ken - The 2 views are in the same schema,  but the underlying tables are in 2 different schemas.  That said, if I run "SELECT * FROM ViewA"...

Msg 230, Level 14, State 1, Line 8

The SELECT permission was denied on the column 'PasswordColumn' of the object 'AuditTable', database 'MyDB', schema 'MySchema'.

Nowhere in the query or view definition...

I agree with you, but that's not possible at this time for us.  I'm trying to solve the permissions problem I posted.

Eirikur Eiriksson (4/6/2015)

---

pveilleux (4/6/2015)

---

It was not running. The 2005 server is a production server and the 2012...

It was not running. The 2005 server is a production server and the 2012 instances (sql101, sql102)...

Eirikur Eiriksson (4/6/2015)

---

pveilleux (4/6/2015)

---

I also went ahead and disabled Named Pipes on sql102, tried the queries, enabled Named Pipes, tried queries again. Everything on sql102 is behaving just...

I also went ahead and disabled Named Pipes on sql102, tried the queries, enabled Named Pipes, tried queries again. Everything on sql102 is behaving just fine. As...

I did not disable Named Pipes on sql101 because it is not disabled on sql102. From sql102, I can get to SQL2005INST no problem. In fact, from sql101,...

No, we're not using Named Pipes to connect. Not sure why that is coming back in the message.

Just for giggles, with the same set up, I tried to run...

No idea. My post is almost a year and a half old, and references something from my last job. I left about 2 months after I posted this....

opc.three (6/6/2012)

---

You say they are sysadmins, well they could be doing something like this which does not require them to know the password of the service account and would still...

SQLKnowItAll (6/6/2012)

---

pveilleux (6/6/2012)

---

SQLKnowItAll (6/6/2012)

---

If someone is a sysadmin, they are automatically in all fixed database roles. They have full access. You could add an SQL Agent role, or...

SQLKnowItAll (6/6/2012)

---

If someone is a sysadmin, they are automatically in all fixed database roles. They have full access. You could add an SQL Agent role, or take it...