Search
Home IIS.NET Forums IIS 5 & IIS 6 Publishing deploy crystal report web application show logon failed to database
Last post May 18, 2012 11:19 AM by mammadov adil
12 Posts
Jul 06, 2011 10:15 AM|LINK
still the same error
this problem is not solved so far
8048 Posts
Jul 09, 2011 07:59 AM|LINK
Hello,
You may find additional information:
http://blogs.iis.net/bills/archive/2009/10/07/error-connecting-to-sql-server-from-windows-7-windows-2008-r2-with-asp-net.aspx
connection problems for SQL Server and the User with Profile permissions.
along with the information above Microsoft Support Article http://support.microsoft.com/?kbid=2002980 for
Security changes and Network Accounts and Permissions.
HTH
Martin
1 Post
Sep 12, 2011 08:08 PM|LINK
I have the same probelm and can you please help me if it got resolved?
Sep 14, 2011 11:20 PM|LINK
Hello @ cterli,
Did you try the Answer from Jeff ?
A) Permissions and the account are different between IIS and Visual Studio. B) Use the correct account and ensure it has permissions to the database. The Longer version: The Crystal Reports Application with Database running in Visual Studio should not be considered. I ) The Crystal Reports Database needs a CR_User with permissions (Logon Access). II) The Crystal Reports Application needs a CR_User with permissions ( Logon Access). III) The IIS Server needs to have the CR_User with permissions for the Server Files Folders for the Crystal Reports Application and Web Site.
A) Permissions and the account are different between IIS and Visual Studio.
B) Use the correct account and ensure it has permissions to the database.
The Longer version:
The Crystal Reports Application with Database running in Visual Studio should not be considered.
I ) The Crystal Reports Database needs a CR_User with permissions (Logon Access).
II) The Crystal Reports Application needs a CR_User with permissions ( Logon Access).
III) The IIS Server needs to have the CR_User with permissions for the Server Files Folders for the Crystal Reports Application
and Web Site.
When you say "I have the same probelm." may not be true it depends on many other variables.
I am not sure that you have exactly the same Windows System IIS Server version version of Crystal Reports
or SQL Server Database configuration as the op Post and thread.
So if you use Jeff's Answer and it does not work you need to open a new Thread.
Sep 15, 2011 04:07 AM|LINK
after asking in crystal report forum, it is solved by special code for 8.5 crystal report. Now all reports can be displayed.
May 18, 2012 11:19 AM|LINK
Fitmation
12 Posts
Re: deploy crystal report web application show logon failed to database
Jul 06, 2011 10:15 AM|LINK
still the same error
Fitmation
12 Posts
Re: deploy crystal report web application show logon failed to database
Jul 06, 2011 10:15 AM|LINK
this problem is not solved so far
HCamper
8048 Posts
Re: deploy crystal report web application show logon failed to database
Jul 09, 2011 07:59 AM|LINK
Hello,
You may find additional information:
http://blogs.iis.net/bills/archive/2009/10/07/error-connecting-to-sql-server-from-windows-7-windows-2008-r2-with-asp-net.aspx
connection problems for SQL Server and the User with Profile permissions.
along with the information above Microsoft Support Article http://support.microsoft.com/?kbid=2002980 for
Security changes and Network Accounts and Permissions.
HTH
Martin
Community Member Award 2011
cterli
1 Post
Re: deploy crystal report web application show logon failed to database
Sep 12, 2011 08:08 PM|LINK
I have the same probelm and can you please help me if it got resolved?
HCamper
8048 Posts
Re: deploy crystal report web application show logon failed to database
Sep 14, 2011 11:20 PM|LINK
Hello @ cterli,
Did you try the Answer from Jeff ?
When you say "I have the same probelm." may not be true it depends on many other variables.
I am not sure that you have exactly the same Windows System IIS Server version version of Crystal Reports
or SQL Server Database configuration as the op Post and thread.
So if you use Jeff's Answer and it does not work you need to open a new Thread.
Martin
Community Member Award 2011
Fitmation
12 Posts
Re: deploy crystal report web application show logon failed to database
Sep 15, 2011 04:07 AM|LINK
after asking in crystal report forum, it is solved by special code for 8.5 crystal report. Now all reports can be displayed.
Mammadov Adi...
1 Post
Re: deploy crystal report web application show logon failed to database
May 18, 2012 11:19 AM|LINK