DESCRIPTION
This article describes the reasons and resolutions for the error logon failed when running reports.
DETAIL STEPS
Situations;
1. All users are unable to run one report from the menu with the error "Logon Failed".
2. One or more users are unable to run any report with the error "Logon Failed".
Resolutions
1. When all users are unable to runt he report it is most likely caused by an error on the report, such as the report being modified while connected to an incorrect database. This error should be corrected by a trained Crystal Report user, who will reconnect all the fields to your database.
2. When all reports are affected there are at least two possible reasons for the error.
a. The DSN is not setup correctly (This is normally setup by the software when a report is first run), try running the software and a report as the windows administrator who has full permissions and the DSN should be correctly created.
b. The Windows user has not been allowed permission to the database. When the software runs, it runs as a special user to connect to the database, however when a report is run it is trying to access the database via windows user authentication.
To resolve this error;
- Login to the windows server as the domain Administrator / administrator
- Connect to the database using the program called "SQL Server Management Studio"
- Use windows authentication when login is requested
- On the left hand side expand the list to find your database (Databases, "DPL-WMSSQL", Security, Users), generally called "DPL-WMSSQL".
- Review the list to ensure it contains all required windows users/windows groups.
If the permission group is not included it can be added via the below.
- Minimised all the expanded fields
- You will now see a header group called security Expand this to show "Logins"
- Right click and select "New Login".
- Enter the login/group name if you know it or find it via the search menu.
- Select "User Mapping" on the left hand side.
- Tick the Database Name checkbox
- Select all the security boxes at the bottom, being sure to exclude the deny options and the Owner option.
- Click OK
- Retry Report
NOTE
User Groups and Windows Server information can be obtained from your System Administrator.
Related articles