Posted by Erland Sommarskog on 10/05/07 21:43

Teresa Masino (teresa.masino@peninsula.org) writes:
> If I log into Query Analyzer as the application user and select from
> the table, I see the same error. If I use ownername.tablename where
> ownername is the same as the login name I am using, then it works
> fine. It's like SQL Server isn't recognizing the account as being the
> same as the object owner.
>
> I ran sp_changeobjectowner to change ownership to dbo and then ran it
> again to change it back to the application account, and it still acts
> like the object owner is not the object owner.
>
> The quick solution was to change all objects to be owned by dbo -- I
> checked with the vendor to make sure they didn't have any objections.
> But I really would like to figure out why it was happening.

Did you use sp_helpuser? It's a good tool to find user/login mismatches.
A lot easier than looking at SIDs.

One possible explanation is that the login was the database owner on
the new server. In this case, the login does not map to ownername,
but to dbo.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]