Reporting services connection logon failed

Question

I am trying to connect to the Database using Windows 'integrated security'. I am getting Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I have the following connection string.

Data Source=testDB;Initial Catalog=test1;Integrated Security=SSPI 

Could you please let me know if there are any suggestions? Thank you.

Answer 1

Check these out - 

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0c999501-5394-4f24-986b-ba18293425b3/

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/22994595-0406-4165-abc8-ad8c8fa3d4d9/

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/240124f5-a400-4443-be5a-6ca3e0a93d00/

Answer 2

Looks you have some issues with SSRS configuration please check here to configure service

http://www.mssqltips.com/sqlservertip/1453/sql-server-reporting-services-configuration-tool/

---

http://uk.linkedin.com/in/ramjaddu

Answer 3

Thanks for the link. I am using the Built-in account as 'Network Service' for service account. Do I have to change the coount?

Answer 4

Hi anate,

Thanks for your post.

Whenever you use Windows Authentication to connect to the specified database, you need to assign the accessing right of the relevant database to your current windows login. Please refer to the steps below:
1. Use SSMS to connect to the TestDB.
2. Expand the Security node.
3. Right-click Logins node, select New login.
4. Type in your windows login (such as domain\name)as login name.
5. Switch to Server Roles tab, check the public and sysadmin checkbox.
6. Switch to Users Mapping tab, check the test1 Database in the first section, and check the db_owner and public roles in the below section.
7. Click ok to finish.

Thanks,
Bill Lu

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.