crystal report "logon failed" on windows server 2003

[sztonix]

Hi all,

I encountered a crystal report deployment problem.

I make reports with Crystal Report for Visual Studio .NET 2003. It
works fine in the development machine. And then make setup package.

Installed on a windows server 2003 system (without visual studio .net
2003), the report gives error about "Logon Failed". The data source is
specified to OLE DB SQL Server, and the LogOnInfo is specified by
codes. And I've tried both local sql server and remote sql server to
the web server, all are failed.

Other than the crystal report part, the web application accesses the
sql server database via asp.net, and it works well.

If installed on a windows server 2003 with visual studio .net 2003, it
works ok. And if installed on a windows xp professional without visual
studio .net 2003, it works ok too.

I've searched out an article in crystal's support, about to change
IIS's application pool's identity from "Network Service" to "Local
System". But it doesnt work either.

Any help or hints are appreciated. Thanks!

Best Regards,
Tonix

[sztonix]

Hi, I've got the point what's wrong. The sql server's collating
sequence is not compatible with the web server. After i install "East
Asian Language Files", it gets ok. I have to complain that the error
message from Crystal Report is really too thin.


[email]sztonix@hotmail.com[/email] (sztonix) wrote in message news:<fd6feb12.0406260245.25853d46@posting.google. com>...

> Hi all,
>
> I encountered a crystal report deployment problem.
>
> I make reports with Crystal Report for Visual Studio .NET 2003. It
> works fine in the development machine. And then make setup package.
>
> Installed on a windows server 2003 system (without visual studio .net
> 2003), the report gives error about "Logon Failed". The data source is
> specified to OLE DB SQL Server, and the LogOnInfo is specified by
> codes. And I've tried both local sql server and remote sql server to
> the web server, all are failed.
>
> Other than the crystal report part, the web application accesses the
> sql server database via asp.net, and it works well.
>
> If installed on a windows server 2003 with visual studio .net 2003, it
> works ok. And if installed on a windows xp professional without visual
> studio .net 2003, it works ok too.
>
> I've searched out an article in crystal's support, about to change
> IIS's application pool's identity from "Network Service" to "Local
> System". But it doesnt work either.
>
> Any help or hints are appreciated. Thanks!
>
> Best Regards,
> Tonix