SQL Server 2000 Serivice Pack 3 - Crystal Reports

[tammybaski]

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 authentication for creating the DSN. I am using ODBC connection in the Design mode of Crystal Reports. No changes have been made to the reports. None of the reports show the result without prompting for the user id and password.

Is there any other patch available for crystal reports to avoid this situation?

Appreciate your help

Thanks
Tammy

 

[roatis]

Anytime you update SQL Server, the authentication is reset. If you have verified the auth method in the DSN after the update, try resetting the location in the reports to see if this clears up the prompting issue. Rod Oatis
Venturi Technology Partners
Crystal Decisions Certified
Trainer/Consultant/Developer/Implementor
Rod_Oatis@hotmail.com

 

[tammybaski]

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 let me know.

Thanks
Tammy

 

[tammybaski]

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