This problem got solved by creating DSN with NT authentication instead of SQL Server authentication. And providing the NT domain authentication for Page Server and Job server under Crystal MMC
Tammy
Rod Thanks for your reply.
I recreated the DSN and I did reset the location in the reports, but still it does prompt for the user id and password. Just as a test, I created a new report, even then, it prompts for the userid and password.
Is there any other solution for this problem.
Please...
I have created many reports using crystal reports and was working perfectly until the new "SQL Server 2000 service pack 3" is applied. After the patch is applied, it started prompting for the user id and password. I am using browser to view the reports.
I am using SQL Server...
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.