When I log to the PC using normal user account  (not administrator) and try to view the report, i get this error "Cannot open SQL Server", but if I use the administrator account, the report is working correctly.

I've tried it using both Windows Vista and Windows XP.

What are the exact privileges or permissions I should assign to the user to be able to view the report? Are there some temporary files created at runtime when generating the reports, if so, where is it located exactly ?

This is soooooooo urgent, can anyone help?

This looks more like a database connection issue than a Crystal permissions issue.  How are you connecting to SQL Server?  Has the SQL Server client software been installed so that the non-admin user has access to it?  What type of connection are you using - ODBC or OleDB?  Does the user have rights to access that type of connection?  Is there an error number that comes up with the message that might be a SQL Server error that you could lookup? 

 

For Crystal, at a minimum, the user needs to be able to add/update/delete files in the Temp (or Tmp) folder that is designated in the environment variables.  This is usually %USERPROFILE%\Local Settings\Temp, but if it's set to something else, that might be causing the problem.  Crystal does a lot of swapping to disk when generating reports.

 

-Dell

Thank you for your reply.

I'm using ODBC connection, other modules in my application that retrieve, insert, update and delete records in the database are working correctly, only the reports are not working.