Crystal Report Viewer Logon Failed Error

Posted on

Crystal report logon failed – We have client-server based on Visual Basic program, this program is running on Windows 7 Professional and connected to the SQL server. The program is working fine, but when we did clean install on other machine there is an error message “Logon Failed” on Cyrstal Report Viewer window when user tried to print a report.

Crystal Report Viewer Logon Failed Error
Logon failed error

We have had check the security credential on SQL server, check the ODBC setting on control panel, tried to add user as local administrator on the client computer, etc. but was not working.

local group - Crystal Report Viewer Logon Failed Error
Add to local group

Later on I found that there is a group on the SQL server called SQLServerMSSQLUser$ranap2$MSSQLSERVER (ranap2 is server name), by adding the domain user account to that local group it solved the problem.

Step by step instruction to fix Crystal Report Logon Failed

On the server SQL server where your database located:

1. Click Start>Control Panel>Administrative tool>Computer management>local users and groups>groups

2. Double click SQLServerMSSQLUser$yourservername$MSSQLSERVER

3. Add user which having error logon failed on crystal report

====================

Below is the server information where Ms SQL server installed:

Software:
OS Windows 2003 Server R2 64 bit edition with Service Pack2

Hardware:
Intel E5440 2.83Ghz RAM 32GB hard disk

SQL:

Microsoft SQL Server Management Studio 10.0.4067.0

Microsoft Analysis Services Client Tools 10.0.4067.0

Microsoft Data Access Components (MDAC) 3.86.3959

Microsoft MSXML 2.6 3.0 6.0

Microsoft Internet Explorer 8.0.6001.18702

Microsoft .NET Framework 2.0.50727.3655

Operating System 5.2.3790

SQL server info - Crystal Report Viewer Logon Failed Error
SQL server information
Facebook Comments