CrystalReports, Login Failed

[Åženol Akbulak]

Hi,

I want to use Crystal Reports in my asp.net application. I get this error:
###
CrystalDecision s.CrystalReport s.Engine.LogOnE xception: Logon failed.
###

I have read this solution and then I applied solution:
http://support.microsoft.com/default...en-us%3B319264
But I still get logon exception.

Is there any other solution?

My Code:
############### ############### ############### #
RL.ReportFiles. Test002 crReportDocumen t = new RL.ReportFiles. Test002();

TableLogOnInfo crTableLogOnInf o = new TableLogOnInfo( );
ConnectionInfo crConnectionInf o = new ConnectionInfo( );

//Crystal Report Properties
CrystalDecision s.CrystalReport s.Engine.Databa se crDatabase;
CrystalDecision s.CrystalReport s.Engine.Tables crTables;

crConnectionInf o.ServerName = "SAKBULAK";
crConnectionInf o.DatabaseName = "BIZDESKDB" ;
crConnectionInf o.UserID = "BIZDESK_login" ;
crConnectionInf o.Password = "bizsengokdesk" ;
crDatabase = crReportDocumen t.Database;
crTables = crDatabase.Tabl es;

foreach(Crystal Decisions.Cryst alReports.Engin e.Table crTable in crTables)
{
crTableLogOnInf o = crTable.LogOnIn fo;
crTableLogOnInf o.ConnectionInf o = crConnectionInf o;
crTable.ApplyLo gOnInfo(crTable LogOnInfo);
}

reportViewer.Re portSource = crReportDocumen t;
############### ############### ############### #
--
_______________ _______________
Åženol Akbulak

[Steven Cheng[MSFT]]

Hi Senol,

Welcome to ASPNET newsgroup.
Looking at the natural of the error you encountered, seems a authentication
security issue. Is the SQLServer you are connecting to using Integrated
authentication or mixed mode? If possible you can turn on the SqlProfiler
on the SQLdb server to see whether there occurs authentication fail message
in the profile log. If occur, that means this is a security authentication
problem. Also, I suggest you try test from a simple report first , that'll
help make the problem more convenient to isolate.

In addition, I've found some similiar issue in the public group and some
others also provide some info:

http://www.vbcity.com/forums/faq.asp...stal%20Reports

If you still have no luck on this, I recommend that you try contacting the
CR support guys or newsgroup for some further assistance since this is a
common issue, there may have more sophisticated TS means on this.

#How To Get Help with Crystal Reports - International and U.S.
http://support.microsoft.com/default.aspx?id=100368

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Åženol Akbulak]

Hi Steven,

My DB is on SQL Server. I used profiler and I saw "login failed" audit on
profiler log. And I see also that although I write this code:
#########
crConnectionInf o.UserID = "MYUSER";
crConnectionInf o.Password = "MYPASSWORD ";
crDatabase = crReportDocumen t.Database;
crTables = crDatabase.Tabl es;

foreach(Crystal Decisions.Cryst alReports.Engin e.Table crTable in crTables)
{
crTableLogOnInf o = crTable.LogOnIn fo;
crTableLogOnInf o.ConnectionInf o = crConnectionInf o;
crTable.ApplyLo gOnInfo(crTable LogOnInfo);
}
#########
it seems LoginUser is "NT AUTHORITY\NETWO RK SERVICE". I dont want to use
integrated security. But it tries to login with integrated security.
"Steven Cheng[MSFT]" wrote:

Hi Senol,

Welcome to ASPNET newsgroup.
Looking at the natural of the error you encountered, seems a authentication
security issue. Is the SQLServer you are connecting to using Integrated
authentication or mixed mode? If possible you can turn on the SqlProfiler
on the SQLdb server to see whether there occurs authentication fail message
in the profile log. If occur, that means this is a security authentication
problem. Also, I suggest you try test from a simple report first , that'll
help make the problem more convenient to isolate.

In addition, I've found some similiar issue in the public group and some
others also provide some info:

http://www.vbcity.com/forums/faq.asp...stal%20Reports

If you still have no luck on this, I recommend that you try contacting the
CR support guys or newsgroup for some further assistance since this is a
common issue, there may have more sophisticated TS means on this.

#How To Get Help with Crystal Reports - International and U.S.
http://support.microsoft.com/default.aspx?id=100368

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Steven Cheng[MSFT]]

Thanks for your reply Senol,

Not sure what the Crystal Report has done internally on the authentication,
curently what we can check is the SQLServer db's authenticaiton mode, is
it configured as Integrated windows only or mixed mode? If it has already
set as integrated windows only, I'm afraid there must have something in CR
need to configure to use SQLServer authentcation mode. I think you can
contact the CR support guys to see whether they've addressed such problem.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Åženol Akbulak]

Thank you Seteven.

With your help, I relized that I must use mixed mode when I create new
report. I did a successful test.

Thank you again. Have a nice day.

"Steven Cheng[MSFT]" wrote:

Thanks for your reply Senol,

Not sure what the Crystal Report has done internally on the authentication,
curently what we can check is the SQLServer db's authenticaiton mode, is
it configured as Integrated windows only or mixed mode? If it has already
set as integrated windows only, I'm afraid there must have something in CR
need to configure to use SQLServer authentcation mode. I think you can
contact the CR support guys to see whether they've addressed such problem.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Steven Cheng[MSFT]]

Cool!

Wish you good luck!

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)