Strange SQL permissions problem
Here's a weird one I've just encountered. I've got a user who connects to my 2000 SQL Server with MS Access to run some queries as part of an old program. This user has their ODBC connection set up specifying the 'sa' user. However, this particular user suddenly started getting permissions problems trying to complete this routine task. On this particular SQL Server I'd recently (about a week ago) added a login account for a specific Active Directory Security Group, but this particular user is not in this new Security Group. I do have an old Domain Users login that has 'public' access to the database in question, but this has not changed since I joined the company (to my knowledge)
I ponder and wonder and finally fire up Profiler. What do I see? Why, my user is executing two SQL Batch statements as the domain user and all the rest (hundreds of RPC events) as 'sa'. Now I have to figure out what in this Access application is different about these two statements that they're being executed as SQL Batch statements while the rest are all remote procedure calls. Then I get to figure out why the SQL Batch statements are being executed via integrated authentication while the rest are using SQL authentication.
Much strangeness