Recently i faced the issue while creating a DSN to connect to SQL Server from remote machine. I am getting login failure message and below is the error logged in error log file.
Error: 18456, Severity: 14, State: 12
Login failed for user 'admin'. Reason: Login-based server access validation failed with an infrastructure error. Check for previous errors
1. No issue with login name and password as i am able to connect to SQL Server using SSMS.
2. If we specify sysadmin to the failed login then DSN is creating without any issues.
I have executed the below commands to fix the issue in my environment,
GRANT CONNECT SQL TO 'admin'
GRANT CONNECT ON ENDPOINT::'TSQL Default TCP' TO 'admin'
As a quick resolution you can give sysadmin role to user and create dsn and remove the sysadmin role.
- Event ID: 1042 Task Category: None Level: Information Keywords: Classic User: SYSTEM Computer: Vince-ASUSG74SX Description: Ending a Windows Installer transaction: C: Users Vince Desktop DD-WRT SplendidUpgradeWin10VER3130004 data 409.msi. Client Process Id: 13440.
- Event ID 1042 from Microsoft-Windows-FailoverClustering: Catch threats immediately. We work side-by-side with you to rapidly detect cyberthreats and thwart attacks before they cause damage. See what we caught. Did this information help you to resolve the problem? Yes: My problem was resolved.
- Event ID 1042: Ending a Windows Installer transaction: D: Documents downloads tmp EDMarketConnectorwin210.msi. Client Process Id: 1516. Event ID 11707: Product: Elite Dangerous Market Connector - Installation completed successfully.
- Ending a Windows Installer transaction: c: xxxxxx.msi. Client Process Id: 1976. Event id 1042 I have tried to use the opera msi and mst. Allso a capture.
Ending A Windows Installer Transaction Event Id 1042 Download
Ending A Windows Installer Transaction Event Id 1042 2017
The next entry will be for “Event ID 1042″ with the description of “Ending a Windows Installer transaction: C:WindowsInstallerxxxxx.msi”. It should look similar to the picture below. The next entry will be for “Event ID 11728″ with the description of “Product: VIPRE.