Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
daboy1216
Posts: 14
Joined: Wed Mar 09, 2005 7:59 pm

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Post by daboy1216 » Wed Jul 29, 2009 1:32 pm

When attempting to install Vault 4.1.4 Server x64 on a Windows 2008 Enterprise Edition (x64), I get the error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
I'm attempting to connect to SQL Server 2008 Standard Edition (x64) using Windows Authentication. I am an administrator on the SQL Server machine (and therefore a member of sysadmin in SQL Server.) What's strange is that I can connect successfully from the same machine using SQL Server Management Studio 2008 with Windows Authentication. It's because of this last fact that I must put the blame on the Vault installer.

Any ideas?

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Post by Beth » Thu Jul 30, 2009 3:59 pm

Is your SQL server on a different machine? If so then you need to either use SQL authentication, or you need to select Custom for the IIS Process Model, and enter in a domain user that Vault will run under. When you use the machine process model and Windows authentication, it takes a local account and tries to make it the db owner, which only works is the SQL database is local.
Beth Kieler
SourceGear Technical Support

Post Reply