For the past few days I've been testing out YAF on a VM and it's been working well (I've hit a few minor issues here and there but we think it will work well in our environment nonetheless).

Today I started migrating the db to our internal cluster and redundant SQL server. Now I'm hitting a strange issue.

When I start the install process I click "Test Database Connection" and it's all green ("Connection Succeeded"). Then, on the "Initialize Database" page I click "Next" and I get an exception:

Login failed for user 'S-1-9-3-667777270-1154951469-3199456156-3565352592.'.
A severe error occurred on the current command. The results, if any, should be discarded.

The username it's displaying is nothing like the actual username I specified in the db.config file.

Does anyone know what the issue is here?

Here's a relevant part of the exception stack:

[SqlException (0x80131904): Login failed for user 'S-1-9-3-667777270-1154951469-3199456156-3565352592.'.
A severe error occurred on the current command. The results, if any, should be discarded.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1767866
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5352418
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1691
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +69
System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest) +799
System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) +564
System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) +137
System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName, Boolean shouldReconnect) +254
System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName) +147
System.Data.SqlClient.SqlConnection.BeginTransaction() +9
YAF.Classes.Data.LegacyDb.system_initialize_fixaccess(Boolean grant) +64
YAF.Core.Services.InstallUpgradeService.UpgradeDatabase(Boolean fullText, Boolean upgradeExtensions) +51
YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) +1307

OK, I managed to find a solution but I have no idea what the implications are or why I need to do this. If I add ";Pooling=false" to the end of the connection string everything works perfectly.