Professional Web Applications Themes

crystal report "logon failed" on windows server 2003 - Windows Server

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 ...

  1. #1

    Default crystal report "logon failed" on windows server 2003

    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 Guest

  2. #2

    Default Re: crystal report "logon failed" on windows server 2003

    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]sztonixhotmail.com[/email] (sztonix) wrote in message news:<fd6feb12.0406260245.25853d46posting.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
    sztonix Guest

Similar Threads

  1. "Logon As" options for CF in Win 2003 server
    By MShaneW in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: June 16th, 05:37 PM
  2. Replies: 7
    Last Post: October 19th, 04:07 AM
  3. Replies: 2
    Last Post: June 8th, 10:48 PM
  4. Replies: 2
    Last Post: January 16th, 02:50 PM
  5. Capturing a failed login within "windows authentication"
    By Twitch in forum ASP.NET Web Services
    Replies: 0
    Last Post: November 17th, 06:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139