Microsoft KB Archive/186314

= PRB: User: _ Not Defined as a Valid User of Trusted Connection =

Article ID: 186314

Article Last Modified on 3/2/2005

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q186314



SYMPTOMS
While running replication tasks, you may receive the following error:

Login failed- User: _ Reason: Not defined as a valid user of a trusted SQL Server connection.



CAUSE
All replication tasks run under the user context of the SQL Executive startup account. Replication tasks also attempt to use integrated security to connect to the subscriber or publisher. When replication is set up, the user under which the SQL Executive service is running is checked for administrative privileges on the publisher or subscriber. If the correct privileges are present, the system administrator ("sa") account is enabled with RemoteLogin privileges and the tasks use "sa" as the login.

In cases where replication is set up and the SQL Executive account is changed back to LocalSystem, replication tasks attempt to connect to the publisher or subscriber. The domain separator is an underscore character ("_"). Therefore, the account information is NULL for domain name and also NULL for username, so the account under which SQL Executive is running is evaluated to "NULL", followed by the domain separator ("_"), followed by "NULL" again. Thus, only the "_" appears in the error message.



WORKAROUND
To work around this problem, change the SQL Executive account back to an account that has administrative privileges on the publisher or subscriber.

Additional query words: log in on logon admin sqlexec SQLExecutive permission permissions rights repl remote local system

Keywords: kbprb KB186314

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.