Home Forums SQL Server 2008 Security (SS2K8) Not able to access database - but what object is being sought? RE: Not able to access database - but what object is being sought?

  • February 28, 2014 at 4:09 pm

    #1693299

    Erland Sommarskog (2/28/2014)

    So how does that piece of code look like? What line does the error message point to?

    By chance, does the procedure have an EXECUTE AS clause?

    Hello Erland, thanks for your reply. Please see my other reply for a schematic description of the error and code. There is no EXECUTE AS statement in the procedure. But the error line number does fall right next to a procedure call in the web script. I tried checking that procedure, but it's in a different database and doesn't directly reference the database in the error. But maybe some dependent object somewhere along the line does reference the db. I just can't find it yet.

    Thanks again!

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html