Login failed when installing service application

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
 

• Status: Open
• Question Views: 1575
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By tibor.tokie 25 points N/A #94710

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

About tibor.tokie

Questions
1

Answers
157

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 02/10/2012
• Question Category: MS SQL Server