Home Forums Data Warehousing Analysis Services SSAS Cube on one server and SQL Server DB on another - Connection Issues RE: SSAS Cube on one server and SQL Server DB on another - Connection Issues
plmarshall
SSC Veteran
Points: 221
More actions
April 1, 2014 at 6:52 pm
#1702297
The issue was I had to log in using OLE DB SQL Server with "auto" credentials, then I needed to log into the AS server via my company's window's login. No windows authentication for the AS server.
Paul