I have hundreds of these errors saying 'Login failed for user 'Reporting' The user is not associated with a trusted SQL Server connection [CLIENT: ip address]
The ip address is that of the server that sql server is installed on.
Looking in my log file, all looks good until I get to Service Broker manager has started, then I get Error: 18452, Severity: 14 State: 1 then these two lines repeat about every minute, for the last 3 days!
I think I must have just missed a tick box somewhere, but where?
I have been into one of the databases, and input and checked data, both via an application I wrote and SQL Server Management Studio.
I am also having trouble connecting using my application to connect to the database, I can only connect if I use a Windows administrator account (this SQL Server 2005 running on a Windows 2003 Server, with the app on PC running Windows 2000)
Hello Graham,
did you find any solutions for that problem? I'm discovering a similar problem. The state of my error message is 5. According to the following source http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx this means the user is not known. This is correct. Neither the SQL-Server nor the Windows system has such a userid.
The faulty user name is 'Reporting'. What is that user used for? I have set up other SQL Server 2005 servers but was never asked for such a name.
Greetings,
Frank
|||Frank
No, but I haven't had much chance to chase this, too many other issues!
|||I've run into the same problem. As far as I can tell the "Reporting" userid is coming from Symantec Reporting Server for Antivirus or Client Security. Everything seems to be functioning in the Reporting console in Symantec Client security just fine, yet I still get the error. I've tried most of what I can think of to resolve this, but will let you know if I find anything else out. Please do likewise.
Jim
No comments:
Post a Comment