Crystal Report files need sign on when run on website in Windows Server 2003 R2. RRS feed

  • Question

  •  the description as follows:
    1 I developed the crystal report files(*.rpt) with Crystal report 10 in Windows Xp.
    2 these *rpt files work well in Windows XP and Windows Server R1 ,(I use and Crystal report to see report result.)
    3 but when i deploy the website on Windows Server 2003 R2, I can not see the report result with Website and Crystal report. the report prompts me to input
    username and password,but when i input username and password, it can not connect to the Sql Server 2005 too.
    who know the reason and solusion,please help me .
    Wednesday, November 26, 2008 6:00 AM

All replies

  •  just now i have found the error information in 'Event Properties' ->Application
    the information is :
    Source : MSSQLSERVER
    Category : (4)
    Type : Failure Andit
    EventID : 18456
    User : N/A
    Description :  Login failed for user 'sa' [CLIENT:]
    Wednesday, November 26, 2008 7:56 AM