Cannot open SQL Server

some tipical problem i m facing
I have created report in crystal 7, database is in sql 2000
and using odbc to connect to sql
rpt is working perfectly in crystal
'when i am calling through vb6 is giving error

" Run-time error '20599' Cannot open sql server'

when the other reports are working perfectly and when i am running any old report after that when i call these rpt its start working but with half selection formulas

when i am calling these rpt first its gives above error
what could be problem

Me also facing the same problem. plz help

yes ! I solved it. The user should be given the previlage of system administrator in sql server. I donno whether it's the right way. But it's working fine.