Cannot Open SQL Server

[ashly]

Hi all,

My customer is using WinXP, 2 accounts - Admin & Guest.

I installed a program which run to view report using crystal report through DSN.

When my customer login using Guest account, when he want to view report, then error "Cannot Open SQL Server" came out.

But when my customer login using Admin account, the report can be view.


Any idea

Thanks

[SunshineBH]

Sounds like the Guest account does not have access to the SQL Server. How is your SQL security set up?

[ashly]

i not sure how is the SQL security set up. any guide to refer that?

but when i create the system dsn in guest account instead of administrator account, my report can be view in guest account, not administrator account.