I have a user who is upgrading her workstation. On her windows 2000, Office
2000 machine the applications work fine.

On her WinXP OfficeXP box, the application opens up, but eventually suffers
a permission error on a storeprocedure. What gives?

She is logging in as the same AD user who has rights in SQL and appropriate
permissions assigned to her role. What is causing the problem?

Any help is greatly appreciated!

Chris

Which application is it? It sounds like a user login is being used instead
of a application role. The most helpful troubleshooter I can think of is to
use SQL Profiler to capture what logon is being used.



--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

*******************************************************************