2503422 - [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user DOMAIN\SERVER$ in SAP Analytics Cloud

Importing data from a SAP BusinessObjects Business Intelligence Universe (UNX) in SAP Analytics Cloud you see the following error after selecting objects from the universe:

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user DOMAIN\SERVER$

• SAP Analytics Cloud 2017
• SAP BusinessObjects Business Intelligence 4.x

The Universe in question is using an ODBC connection with authentication settings set to use the WinNT user.

Change the authentication method for the connection in Information Design Tool to use SQL Authentication.

SAP Analytics Cloud does not support Kerberos SSO in order to send a valid Windows user from the application to the BI Platform universe.

• Help resources
• Help portal
• SAP Community ( Questions & Answers / Direct Link to Create Question / Blogs )
• SAP community wiki
• Ideaplace forum ( for enhancement requests & new features )
• Video tutorials 
• Videos by topic areas: ( Overview, What's New, Models and Connections, Stories, SAP Digital Boardroom, Planning, Predictive, Collaboration, Administration )
• Training events
• Past event recordings
• New user handbook
• Roadmap
• How to connect to on-premise data
• Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem