My guess is that the user is able to login b/c of the guest account on the db: are you certain that the users SQL Server account is synched with the NT account? Totally a shot in the dark.
-- Integrated security error occurs because SQL Server cannot find a SQL Server account for the NT account.
Solution: To resolve this problem, check the NT account trying to access the database and make sure it maps to the correct SQL Server account.
If the mapping is okay, check the account...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.