Hi,

I am hosting a website which contains around 10 reports. All were working until yesterday. Now I have done some database DDL changes. I want them to reflect in crystal reports also. I did that on one of the reports. I just verified the report and uploaded on the server. Now I am receiving following error in generating the same report:

Logon failed. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection. SQL State: 08001 Native Error: Error in File C:\Windows\TEMP\quotation_print {6ECFB4B2-5188-4C8C-892E-8A3EA28CB2D9}.rpt: Unable to connect: incorrect log on parameters.

This is very strange as I am passing dynamic connection string to the report and which is exactly same for all the reports. All others are running and this one stopped working.

Given below are the technologies I am using:

Website development tool: Visual Studio 2008
Programming Language: C#
Reporting Tool: Crystal reports bundled with Visual Studio 2008
Database: SQL Server 2008 R2

I will really appreciate if somebody can help me. Please let me know if you have questions.