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?
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Moderator: SourceGear
Re: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
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
SourceGear Technical Support