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
 SSRS user credentials - old account

Author  Topic 

DLTaylor
Posting Yak Master

136 Posts

Posted - 2010-02-11 : 09:11:01
Hello,

I have a Windows 2003 server running SQL 2005 SP3.

A user named; KWright setup & installed SQL 2005 (inc) the Report Server & configured SSRS.

The user has now left the buisness and the account Deactivated within Active Directory.

The SSRS reports are accessed using a Windows Authentication and all are running ok - when required.

However (for want of a better word)in the Active Directory Log file - each time a report is executed - it generates an error saying a 'Bad User Name' KWright.

I have looked around the SSRS configuration manager & data sources and cannot see a reference to KWright.

My question is... where might the old user account KWright be getting referenced at report runtime?
(Remembering the reports run ok - but just adds a 'bad user name to the active directory log)

Any pointers will really help.
   

- Advertisement -