I have searched the forum and cannot find a conclusive answer.
I am attempting to use the SQL Server bulk load stage, however am getting the DataStage error:
"SQL server OLEDB provider authorization failed."
The database log contains:
"12/06/2007 09:36:26,Logon,Unknown,Login failed for user 'xxxxxx'. [CLIENT: 10.8.6.37]
12/06/2007 09:36:26,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5."
10.8.6.37 is our ETL server.
The database is on a separate server.
The DS doco states the stage uses MDAC, however does not state on which server it should be installed, the ETL or database.
The username and password do connect to the database, and according the our DBA there is no reason why we cannot bulk load.
Can anyone shed any light on this?
Thanks
Adamski
SQL Server Bulk Loader Stage
Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration