Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Login Failed

Author  Topic 

rock1233
Starting Member

4 Posts

Posted - 2008-08-22 : 14:27:14
hello everybody
i have a login problem :
i am using SQL Server 2005
1)i enter the management studio successfully .
2)in the object explorer, i try to connect to Reporting Services choosing Windows Authentication but i get an error dialog box and in the log file i get the following error message : "Login Failed for user 'ASSAAD'. The user is not associated with a trusted SQL Server connection. [Client : <local machine>]"

Please note that i am using my local computer and the user 'ASSAAD' is the computer administrator account. And i dont have this error when i try to connect to the database engine or to the integrated services. I only get this error when i connect to the Reporting Services.
Can somebody help me solving this problem please ?
thank you all in advance.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-22 : 14:54:34
What account do you see in SQL server config manager for Reporting services?
Go to Top of Page

rock1233
Starting Member

4 Posts

Posted - 2008-08-23 : 11:45:23
hi sodeep
It is : NT Authority\LocalService .
I found it in the SQL server configuration manager for Reporting services under "Log On As" .
Go to Top of Page
   

- Advertisement -