Asked By
natchavez
0 points
N/A
Posted on - 02/02/2012
Hi
For the preparation on SQLBits 9 conference, I have passed a number of times on making virtual environments to manifest Microsoft business intelligence goods. While I want to form a service application and alternative for Power Pivot I am facing a problem continuously according with the text “Error. Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’.”
Give me a solution please. Thanks a lot.
Error
Error
Login failed for user 'NT AUTHORITYANONYMOUS LOGON.'
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: e2cd5977-bcdd-4d23-8707-fc0eb0806faB
Date and Time: 10/3/2011 2:14:34 PM
• Go back to site
Login failed when installing service application
Dear Natchavez
According to the error message you applied "Login failed for user 'NT AUTHORITYANONYMOUS LOGON", this error is because SQL Server doesn't have the login account for your windows. I think your SQL server database is on remote machine and the application server IIS has the option Impersonate set to true. Try to set the Impersonate to false and create a log in account in your DB server with domain_nameapp_machine_name$. this may resolve your problem. If you didn't change the Impersonate option, this error will only appear on the application server machine and not the client machines. Another solution is about trying to change the connection string driver to SQL Native Client.
Hope this may help you.
Best of luck