Matthew Nguyen (11/3/2011)
I used to have SSRS installed on this SQL box and I already removed SSRS by going to "program and features" (proper way to uninstall SSRS). Any way, it's already been removed and I removed SSRS DBs afterward.Now, I kept getting error"
"Login failed for user 'domain\blah' Reason: Failed to open the explicity specified databas. [Client: <local machine>}.
Based from some research, this error is related to SSRS and I already cleaned it up and its DBs, now I just want to clean up the errors.
Can someone tell me how to get rid of this error?
thanks
This error means some user is trying to connect, but cant connect to the database it's looking for. Based on what you said, it probably doesnt exist anymore. Also, client: local machine is telling you that the connection is coming from the same server that hosts the database. Take a look at the user in question- what is it's default database- does it exist? What application or service is running under that user? it's still trying to connect to your database server. One way to find out more detail is to run a profiler trace and capture failed logins (under security audit)... this will show you the "client process id". With that you can identify what process is trying to log in to your database server and access a database which it does not have permission to (or does not exist).