Table of contents
Login failed for user 'dtw_newtest'
Review details problem
Login failed for user 'dtw_newtest'. [CLIENT: 10.166.67.27] observed in the archive log data warehouse.
Solution(s)
Check the password of the datasource NewtestDWH.
Specific case - Setting provider "Native OLE DB \ Microsoft OLE DB Provider for SQL Server" at the datasource NewtestDW instead of "Native OLE DB \ SQL Native Client"
- Increase the maximum number of connections to 50 of the datasource
Comments