Crystal report logon failed – We have client-server based on the 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 a clean install on other machines there is an error message “Logon Failed” on Cyrstal Report Viewer window when a user tried to print a report.
We have had to check the security credential on SQL server, check the ODBC setting on the control panel, tried to add a user as a local administrator on the client computer, etc. but was not working.
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:
OS Windows 2003 Server R2 64 bit edition with Service Pack2
Intel E5440 2.83Ghz RAM 32GB hard disk
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