I installed SQL Analysis Services. I want to test it via Excel Services on SharePoint.

I created new account with which I can easily login to SQL Server Management Studio: the username and password are demonstrably correct.

After that, I made a new Excel workbook and connected it with the database. I provided the account details created before and everything it works.

Then I tried to upload a workbook to the SharePoint Document Library. Upload is successful, but when i want to refresh the data there I get this error in the SQL log:

"Login failed for user 'Darko'. Reason: Password did not match that for the login provided."

What password is not matching? I can easily login to SQL Server Management Studio. I tried with the "sa" account but get the same result. I've set "SQL Server and Windows Authentication" in server properties. How do I fix or diagnose this issue?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.