Notifications
Clear all

[Solved] PowerPivot in Excel 2016: OLE DB or ODBC error. Login failed for user

 

Joined: 8 years ago
Posts: 10
Topic starter  

When I try to get data in the table import wizard into PowerPivot, I get the message: OLE DB or ODBC error. Login failed for user ‘mike.farmer’.; 28000. A connection could not be made to the data source.

and 


Quote
Joined: 8 years ago
Posts: 10
Topic starter  

This problem occurs in Excel 2016.

1. Go to PowerPivot – Get External Data – From Database – From SQL Server
2. In the Connect to a Microsoft SQL Server Database window, add Server Name, SQL Authentication, Password and the Database Name.
3. Then, click ADVANCED.
4. Set Persist Security Info to false.

 

This will fix the problem.

Watch our video here:  https://youtu.be/n-LDK55BEeA


ReplyQuote
Share: